Table of Contents

Search

  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

Cell Data Survivorship and Order of Precedence

Cell Data Survivorship and Order of Precedence

During the evaluation of cells to merge from two records, the MDM Hub determines which cell data survives and which data to discard. The MDM Hub considers the surviving cell data, or winning cell, to represent the better version of the truth between the two cells. Ultimately, a single, consolidated record contains the best surviving cell data and represents the best version of the truth.
Survivorship applies to both trust-enabled columns and columns that are not trust enabled. When the MDM Hub compares cells from two different records, it determines survivorship based on the following factors, in order of precedence:
  1. By trust score. The trust score applies only if a column is trust-enabled. The data with the highest ROWID_OBJECT wins. If the trust scores are equal, or if trust is not enabled for a column, the MDM Hub proceeds to the next comparison.
  2. By SRC_LUD in the cross-reference record. The data with the more recent cross-reference SRC_LUD value wins. If the SRC_LUD values are equal, the MDM Hub proceeds to the next comparison.
  3. By ROWID_OBJECT in the base object. ROWID_OBJECT values are evaluated in numeric descending order. If the ROWID_OBJECT values are equal, the MDM Hub proceeds to the next comparison.
  4. By ROWID_XREF in the cross-reference. ROWID_XREF values are evaluated in numeric descending order. The data with the highest ROWID_XREF wins.

0 COMMENTS

We’d like to hear from you!