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

About Cross-Reference Tables

About Cross-Reference Tables

Each base object has one associated cross-reference (XREF) table. The XREF table tracks the lineage and, if timeline is enabled, the records versions for different effective periods.
Informatica MDM Hub automatically creates a cross-reference table when you create a base object. Informatica MDM Hub uses cross-reference tables to translate all source system identifiers into the appropriate ROWID_OBJECT values.

Records in Cross-Reference Tables

Each row in the cross-reference table represents a separate record from a source system. If multiple sources provide data for a single column (for example, the phone number comes from both the CRM and ERP systems), then the cross-reference table contains separate records from each source system. For timeline-enabled base objects, the cross-reference table also contains separate records for each version of a base object record. Each base object record has one or more associated cross-reference records.
The cross-reference record contains:
  • An identifier for the source system that provided the record.
  • The primary key value of that record in the source system.
  • The most recent cell values provided by that system.
  • The original ROWID_OBJECT value of the record.
  • The original GBID value of the record, if applicable.
  • The start date and end date of the period of effectiveness of the record, if applicable.

Load Process and Cross-Reference Tables

The load process populates cross-reference tables. During load inserts, new records are added to the cross-reference table. During load updates, changes are written to the affected cross-reference records.

Data Steward Tools and Cross-Reference Tables

Cross-reference records are visible in the Merge Manager and can be modified using the Data Manager. For more information, see the
Multidomain MDM Data Steward Guide


We’d like to hear from you!