What the trust for ABC source system for Valid Ind column?
Let' s say,
Source=PQR, valid ind =N (trust 70)
Source=ABC, valid ind =Y (trust 70).
And you are downgrading Trust by some percentage (say downgrading by 10% ) for valid ind =N, In that case valid ind =N would have Trust 63% and valid ind =Y would be having Trust 70%. So Y will win and bubble up in BO table.
While merging two records (either auto-match & merge or manual merge), the following rules are applied to decide the survivorship of the records:
- When a consolidated record is merged with a non-consolidated record, the consolidated record survives.
- When two consolidated records are merged, the older record, that is, the one with a lower rowid survives.
- When two unconsolidated records are merged, it is not possible to control or override the behavior as to which one survives.
Please refer to Cell Data Survivorship and Order of Precedence in the MDM Configuration Guide for the order of Precedence.
The example doesn't explain below factors which determines your outcome.
-- trust config values for Valid_ind column for each source
-- validation rule if any and its downgrade percent
-- If Allow NULLs enabled for Valid_ind column
So going by blind assumption that PQR is higher trusted than ABC, then value N will survive on both Day1 and Day2