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

How the Consolidation Indicator Changes

How the Consolidation Indicator Changes

Informatica MDM Hub
updates the consolidation indicator for base object records in the following sequence.
  1. During the load process, when a new record is loaded into a base object,
    Informatica MDM Hub
    assigns the record a consolidation indicator of 4, indicating that the record needs to be matched.
  2. Near the start of the match process, when a record is selected as a match candidate, the match process changes its consolidation indicator to 3.
    Any change to the match or merge configuration settings will trigger a reset match dialog, asking whether you want to reset the records in the base object (change the consolidation indicator to 4, ready for match).
  3. Before completing, the match process changes the consolidation indicator of match candidate records to 2 (ready for consolidation). If you perform a manual merge, the data steward performs a manual match, and the consolidation indicator of the merged record is 2.
    The match process may or may not have found matches for the record.
    A record with a consolidation indicator of 2 is visible in Merge Manager.
  4. If Accept All Unmatched Rows as Unique is enabled, and a record has undergone the match process but no matches were found, then
    Informatica MDM Hub
    automatically changes its consolidation indicator to 1 (unique).
  5. If Accept All Unmatched Rows as Unique is enabled, after the record has undergone the consolidate process, and once a record has no more duplicates to merge with,
    Informatica MDM Hub
    changes its consolidation indicator to 1, meaning that this record is unique in the base object, and that it represents the master record (best version of the truth) for that entity in the base object.
    Once a record has its consolidation indicator set to 1,
    Informatica MDM Hub
    will never directly match it against any other record. New or updated records (with a consolidation indicator of 4) can be matched against consolidated records.


We’d like to hear from you!