The load process calculates trust for trust-enabled columns in the base object. For records with trust-enabled columns, the load process assigns a trust score to cell data. This trust score is initially based on the configured trust settings for that column. The trust score may be subsequently downgraded when the load process applies validation rules—if configured for a trust-enabled column—after the trust calculations.
All trust calculations are based on the system date with one exception; trust calculations for historic queries on timeline-enabled base objects are based on the historical date. Trust calculations for trust-enabled base objects are not based on effective dates.
Trust Calculations for Load Update Operations
During the load process, if a record in the staging table will be used for a load update operation, and if that record contains a changed cell value in a trust-enabled column, the load process calculates trust scores for:
the cell data in the source record in the staging table (which contains the updated information)
the cell data in the target record in the base object (which contains the existing information)
If the cell data in the source record has a higher trust score than the cell data in the target record, then
Informatica MDM Hub
updates the cell in the base object record with the cell data in the staging table record.
Trust Calculations When Consolidating Two Base Object Records
When two records in a base object are consolidated,
Informatica MDM Hub
calculates the trust score for each trusted column in the two records being merged. Cells with the highest trust scores survive in the final consolidated record. If the trust scores are the same, then