Introduction
Configuring Hub Console Tools
- Configuring Access to Hub Console Tools
- Implementing Custom Buttons in Hub Console Tools
Building the Data Model
Configuring the Data Flow
Executing Informatica MDM Hub Processes
- Using Batch Jobs
- User Exits
Configuring Application Access
MDM Hub Properties
Viewing Configuration Details
Search with Solr
Row-level Locking
MDM Hub Logging
Table Partitioning
- Support for Table Partitioning
Collecting MDM Environment Information with the Product Usage Toolkit
Glossary
- Glossary of Terms

Configuration Guide

10.3 HotFix 2
- 10.5 HotFix 2
- 10.5
- 10.4 HotFix 3
- 10.4 HotFix 2
- 10.4 HotFix 1
- 10.4
- 10.3 HotFix 3
- 10.3 HotFix 1
- 10.3

Back Next

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.

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Configuring Lookups for Foreign-Key Relationships

Configuring Lookups for Foreign-Key Relationships