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:                     State

Table 1 Value for State:        NY

Table 2 Value for State:        034

Table 3 Value for State:        34

Table 4 Value for State:        New York

Entity:                     Auto

Table 1 Value for Auto:        AA

Table 2 Value for Auto:        AU

Table 3 Value for Auto:        01

Table 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 a best practice on how this could be designed within ONE RDM, can you share?

Thank you!