Table of Contents

Search

  1. Introduction
  2. Configuring Hub Console Tools
  3. Building the Data Model
  4. Configuring the Data Flow
  5. Executing Informatica MDM Hub Processes
  6. Configuring Application Access
  7. MDM Hub Properties
  8. Viewing Configuration Details
  9. Search with Solr
  10. Row-level Locking
  11. MDM Hub Logging
  12. Table Partitioning
  13. Collecting MDM Environment Information with the Product Usage Toolkit
  14. Glossary

About Foreign Key Relationships

About Foreign Key Relationships

In
Informatica MDM Hub
, a foreign key relationship establishes an association between two base objects through matching columns. In a foreign-key relationship, one base object, the child, contains a foreign key column, which contains values that match values in the primary key column of another base object, the parent. If the foreign key of a child base object points to ROWID_OBJECT of the parent base object, the foreign key of the associated child cross-reference table points to ROWID_XREF of the associated parent cross-reference table.

Types of Foreign Key Relationships in Operational Reference Store Tables

There are two types of foreign-key relationships in
Hub Store
tables. 
Type
Description
system foreign key relationships
Automatically defined and enforced by
Informatica MDM Hub
to protect the referential integrity of your schema.
user-defined foreign key relations
Custom foreign key relationships that are manually defined according to the instructions later in this section.

0 COMMENTS

We’d like to hear from you!