HI Team ,
We have a requirement as below :-
We have one nested attribute as Communication where we have attributes like Comm type ,value and Is Primary column .
Now on first day data load for a particular entity we received three record in the nested as below :-
On second day we received records of Communications for the same entity as below :-
As you can see in second day the communication with value is not coming from source , rather than a new email has come as primary as old one has been replaced in the source system .So the requirement is any previous/old primary communication which is not coming from source in the input payload ,that has to be detected inside MDM and need to be made non -primary.So after Day 2 data load ,the final result in Communication would be like below :-
Please let us know how to achieve this requirement in Reltio.
------------------------------
Utsa Das
Novartis
------------------------------