For each trust-enabled column in a base object record,
Informatica MDM Hub
maintains a record in a corresponding control table that contains the last update date and an identifier of the source system. Based on these settings,
Informatica MDM Hub
can always calculate the current trust for the column value.
If history is enabled for a base object,
Informatica MDM Hub
also maintains a separate history table for the control table, in addition to history tables for the base object and its cross-reference table.
Cell Values in Base Object Records and Cross-Reference Records
The cross-reference table for a base object contains the most recent value from each source system. By default (without trust settings), the base object contains the most recent value no matter which source system it comes from.
For trust-enabled columns, the cell value in a base object record might not have the same value as its corresponding record in the cross-reference table. Validation rules, which are run during the load process after trust calculations, can downgrade trust for a cell so that a source that had previously provided the cell value might not update the cell.