What would happen in a cross-reference (XREF) table when multiple sources (CRM and ERP systems) provide data for a single column i.e. contact_info?
Assume that trust score for this column for CRM is 80 while the score for ERP is 75 but LAST_UPDATE_DATE for the record from CRM is earlier than that from ERP.

The cross-reference table wouls contain only one record from CRM since its trust score is higher than that of ERP

The cross-reference table wouls contain only one record from ERP since its LAST_UPDATE_DATE is more recent than that of CRM

The cross-reference table would contain separate records from each source system irrespective of their trust scores and LAST_UPDATE_DATE values

Insufficient data to determine

Verified Answer
Correct Option - c

To get all Infosys Certified Informatica MDM Developer Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in