my scenario is i have data from the 3 sources (source 1,source 2 , source 3)in these data i have to give priority to the one column based on source.
For ex: lets take phone number column i have phone number fields in each source if source 1 have phone number field it should take. or if source 1 value is empty or null it should take source 2 phone number value.
if source 2 also empty or null it should take source 3 phone. how i can achieve with this talend data quality or mdm UI or stewardship not with the tmap. please solution to this problem.
Hi
To extract data from data source, we need a DI job, something like:
source1--tJavaRow1...--runIf---source2--tJavaRow2..runIf.-source3---....
Check if phone number is null or empty on tJavaRow
You could do that in DataStewardship. If you create a Merging campaign, you can set the source names and their trust score. For each attribute, you can set a different survivorship rule, if you select "most trusted" the source with the higher trust score is selected as for the golden record.
You could find help on DataStewardship in the documentation, the following links are for the cloud version, it's the same as the on-premise version regarding the merging campaign configuration:
