Skip to main content

Recently active topics

40
Mapping related reference data

Hi All,Does anyone have a best practice for creating mappings between related reference data?Β Β  We need to be able to relate various datasets used by different systems that have the same "entity" but the codes for that entity are different. Some examples:Entity:                     StateTable 1 Value for State:        NYTable 2 Value for State:        034Table 3 Value for State:        34Table 4 Value for State:        New YorkΒ Β Entity:                     AutoTable 1 Value for Auto:        AATable 2 Value for Auto:        AUTable 3 Value for Auto:        01Table 4 value for Auto:        AutoΒ We need to be able to "map" these values within RDM, so we know that NY, 034, 34 and New York are all "State", and that AA, AU, 01 and Auto are all "Auto".Β Β Additionally, these mappings may need to be hierarchical.Β Β In Informatica, these objects are called β€œcrosswalks”, and they exist as base entities within the tool. We need to duplicate that type of behavior.Β If you’ve implemented this, or have

Badge winners

Show all badges

Let's shape the future of Ataccama together

Join User Research at Ataccama!
See new features and prototypes before everyone else, andΒ have an opportunity to shape the future of new products.

Read more