MDM Staging and Loading 2

Question 1

During the delta detection phase in Informatica MDM staging, what is the primary purpose of comparing incoming records against the staging table?

Accepted Answer

To identify new, updated, or unchanged records from the source

Answer

To validate foreign key relationships before loading

Answer

To merge duplicate records into the best version of truth

Answer

To apply trust scores to each incoming attribute

Question 2

Which Informatica MDM staging table stores the raw source data before any cleansing or standardization is applied?

Accepted Answer

_STG table

Answer

_BO table

Answer

_XREF table

Answer

_HIST table

Question 3

In Informatica MDM, what happens to a source record that fails validation during the stage job?

Accepted Answer

It is written to the error table and excluded from further processing

Answer

It is immediately deleted from the source system

Answer

It is auto-corrected by the cleanse functions and reloaded

Answer

It is promoted directly to the base object with a low trust score

Question 4

Which load type in Informatica MDM replaces all existing hub records with incoming source data, regardless of changes?

Accepted Answer

Full load

Answer

Delta load

Answer

Incremental load

Answer

Merge load

Question 5

What is the role of the ROWID_OBJECT column that Informatica MDM assigns during the load process?

Accepted Answer

It is the unique surrogate key MDM generates for each base object record

Answer

It stores the source system's primary key for traceability

Answer

It tracks the number of times a record has been merged

Answer

It holds the trust-weighted confidence score for each record

Question 6

When configuring a batch group in Informatica MDM, which job must typically run BEFORE the load job to ensure data is ready?

Accepted Answer

Stage job

Answer

Match job

Answer

Merge job

Answer

Promote job

Question 7

In Informatica MDM Hub, the XREF table created during load primarily serves which purpose?

Accepted Answer

Maps source system keys to MDM surrogate keys for cross-referencing

Answer

Stores consolidated best-version-of-truth attribute values

Answer

Holds historical versions of records before survivorship

Answer

Tracks match rule execution results per record pair