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

Configuring Lookups

You can configure a lookup through foreign key relationships.
  1. Start the Schema Manager.
  2. Acquire a write lock.
  3. In the schema tree, expand the
    Base Objects
    node, and then expand the node for the base object associated with this staging table.
  4. Select the staging table that you want to configure.
  5. Select the row of the foreign key column that you want to configure.
    Edit Lookup
    button is enabled for foreign key columns.
  6. Click the
    Edit Lookup
    The Schema Manager displays the Define Lookup dialog box.
    The Define Lookup dialog box contains the parent base object and its cross-reference table, along with any unique columns.
  7. Select the target column for the lookup.
    • To define the lookup to a base object, expand the base object and select Rowid_Object, which is the primary key for this base object.
    • To define the lookup to a cross-reference table, select PKey Src Object (the primary key for the source system in this cross-reference table).
    • To define the lookup to any other unique column, select the column.
    When you delete a relationship, it clears the lookup.
  8. If the lookup column is PKey Src Object in the relationship table, select the lookup system from the Lookup System list.
  9. Click
  10. If you want, configure the
    Allow Null Update
    check box to specify what happens if a load job specifies a null value for a cell that already contains a non-null value.
  11. For each column, configure the
    Allow Null Foreign Key
    option to specify what happens if the foreign key column contains a null value (no lookup value is available).
  12. Click the
    button to save your changes.


We’d like to hear from you!