Table of Contents


  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

Configuring Lookups for Foreign-Key Relationships

Configuring Lookups for Foreign-Key Relationships

After you create a foreign key relationship, you can configure a lookup for the column. A lookup causes
Informatica MDM Hub
to retrieve a data value from a parent table during the load process. For example, if an Address staging table includes a CONSUMER_CODE_FK column, you could have
Informatica MDM Hub
perform a lookup to the ROWID_OBJECT column in the Consumer base object and retrieve the ROWID_OBJECT value of the associated parent record in the Consumer table.


We’d like to hear from you!