Configuration Guide

Back Next

Create a Relationship Base Object

To configure match rules for this kind of object, you would create a separate base object to describe to

Informatica MDM Hub

the relationships between records.

For example, you could create and configure a EmplRepRel base object with the following columns:

Column	Type	Description
ROWID_OBJECT	CHAR(14)	Primary key. Uniquely identifies this relationship record.
EMPLOYEE_FK	CHAR(14)	Foreign key to the ROWID_OBJECT of the employee record.
REPORTS_TO_FK	CHAR(14)	Foreign key to the ROWID_OBJECT of a manager record.

The column type of the foreign key columns—CHAR(14)—matches the primary key to which they point.