Foreign Key Relationships:

In MDM Hub, Foreign Key relationship provides a connection between the Base Object through the Match Column. Foreign Key sometimes called Reference table used to link one Base Object contains foreign key (Child table) that make an association with the other Base Table( Parent table).

How To Create Foreign Key Relationships:

In order to configure foreign key relationship in MDM follow the Following steps :

1. Create Parent Table.
2. Create Child Table.
3. Define a foreign relationship.

Adding Foreign Relationships:

1. Start the MDM Hub Console and enter your Login Credentials.
2. Start the Schema Manger -> Acquire Write Lock
3. Click on BO Object -> Expand the child table (that will contain the Foreign Relation)
4. Click on Relationships.
5. Click on Add (+) button. Schema Manager will display Relationship Dialog Box.
6. Now Relate the Child relationship( Left Pane) to Parent BO Object (Right Pane).
7. Relate with with column name with the ROWID_OBJECT of Parent.
8. Click Ok and Save.

Configuring LOOKUP Relationships :

Now after adding the Relationship between Parent and Child BO Object We need to perform Lookup in the Table so that from Parent BO can retrieve the values during the Loading Process. For this

• Create a Staging Table
• Import The Columns.
• Click on the Lookup icon Click
• Schema Manager will show a dialog
• Click on Add(+) the ROWID_OBJECT.
• Click Ok and Save.