Understanding the Consolidation Indicator in Informatica IDMC Customer 360 MDM SaaS

 The Consolidation Indicator (CI) field is a crucial element in Informatica IDMC Customer 360 MDM SaaS, playing a vital role in managing and consolidating data. This indicator helps track the state of data records as they move through the matching and merging process, ultimately leading to the creation of a "best version of truth" for each unique entity.

The CI field can take on four distinct values, each signifying a different stage in the data consolidation lifecycle:

• Match Dirty: This is the initial state for data records when they are first loaded or updated within MDM SaaS. It indicates that the record is new or has been modified and needs to be processed for potential matches.

• Match Index: After the indexing job runs, the CI value transitions from "Match Dirty" to "Match Index." In this state, records are prepared to participate in the matching process. If re-indexing is required for any reason, the CI value can be reset back to "Match Dirty."

• Matched: A record receives the "Matched" CI value once it has gone through the match and merge process. This applies whether a matching candidate was found or not.

• Consolidated: This is the final and most desirable state for a merged record. "Consolidated" signifies that a unique and accurate "best version of truth" record has been successfully created.

---

Beyond these core values, there are several important aspects related to the CI field:

• Accept as Unique: If the "accept as unique" option is enabled for a record that undergoes the match and merge process but doesn't find any matching rules, its state will change from "Match Index" to "Matched." This allows the record to be treated as unique even without a direct match.

• XREF Record Updates: When an XREF (cross-reference) record is updated, its CI value automatically reverts to "Match Index." This ensures that the updated XREF record is re-evaluated through the match and merge process.

• CI Field Location: A key distinction in MDM SaaS compared to on-premise MDM is the placement of the CI field. In MDM SaaS, the CI field is located at the XREF level, not the business entity level. This granular placement provides more precise control over data consolidation.

• Extracting Consolidated Records: To extract only the consolidated records, a two-step extraction process is necessary. This involves creating one extract for business entity records and another for XREF records. These two extracts can then be joined to filter and retrieve only the consolidated values.

---

In summary, the Consolidation Indicator is a fundamental component of Informatica IDMC Customer 360 MDM SaaS, providing clear visibility into the data consolidation journey and enabling robust data management practices.