Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: 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!