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: Informatica Platform Staging
  15. Appendix H: Informatica Platform Mapping Examples
  16. Appendix I: Glossary

Foreign Key Relationship Base Objects

Foreign Key Relationship Base Objects

A foreign key relationship base object is an entity base object with a foreign key to another entity base object.
You must have an entity base object and add a foreign key column to convert to a foreign key relationship base object.
When you create a foreign key relationship base object, you select the entity base object to add a foreign key column to.
Field
Description
FK Constraint Entity BO 1
Select FK entity base object from the list.
Existing BO Column to Use
Name of existing base object column used for the foreign key, or choose to create a new column.
FK Column Display Name 1
Name of FK column as it will be displayed in the Hub Console.
FK Column Physical Name 1
Actual name of FK column in the database. The Hub Console suggests a physical name for the table based on the display name that you enter.
FK Column Represents
Choose Entity1 or Entity2, depending on what the FK Column represents in the relationship.
To use foreign key relationships, create the entity base objects you want to relate. Use foreign key relationships when you have a one-to-many relationship between entities.
When you create the foreign key relationship, you need to add a foreign key column for each entity you want to relate to.

0 COMMENTS

We’d like to hear from you!