What is ROWID_OBJECT and ORIG_ROWID_OBJECT in Informatica MDM and what is significance?

 In Informatica Master Data Management (MDM), ROWID_OBJECT and ORIG_ROWID_OBJECT are critical identifiers within the MDM data model, particularly within the context of data storage and entity resolution.

ROWID_OBJECT

• Definition: ROWID_OBJECT is a unique identifier assigned to each record in a base object table in Informatica MDM. It is automatically generated by the system and is used to uniquely identify each record in the MDM repository.
• Significance:
  • Uniqueness: Ensures that each record can be uniquely identified within the MDM system.
  • Record Tracking: Facilitates tracking and managing records within the MDM system.
  • Entity Resolution: Plays a crucial role in the matching and merging processes. When records are matched and merged, the surviving record retains its ROWID_OBJECT, ensuring consistent tracking of the master record.

ORIG_ROWID_OBJECT

• Definition: ORIG_ROWID_OBJECT represents the original ROWID_OBJECT of a record before it was merged into another record. When records are consolidated or merged in the MDM process, the ORIG_ROWID_OBJECT helps in maintaining a reference to the original record's identifier.
• Significance:
  • Audit Trail: Provides an audit trail by retaining the original identifier of records that have been merged. This is crucial for data lineage and historical tracking.
  • Reference Integrity: Ensures that even after records are merged, there is a way to trace back to the original records, which is important for understanding the data's history and origin.
  • Reconciliation: Aids in reconciling merged records with their original sources, making it easier to manage and understand the transformation and consolidation processes that the data has undergone.

So, ROWID_OBJECT ensures each record in the MDM system is uniquely identifiable, while ORIG_ROWID_OBJECT maintains a link to the original record after merging, providing critical traceability and auditability in the MDM processes.

Learn more about ROWID_OBJECT in Informatica MDM here -