MDM Staging and Loading 4

Question 1

When configuring a source system in Informatica MDM Hub Console, which setting determines the default trust level assigned to records from that source during load?

Accepted Answer

Source system trust settings

Answer

Trust settings defined per source system establish the baseline confidence score MDM assigns to each attribute from that source, influencing survivorship decisions during load.

Question 2

During a full load in Informatica MDM, which table is truncated before new data is inserted to ensure a clean state?

Accepted Answer

Staging (_STG) table

Answer

In a full load, the staging _STG table is cleared before the source data is re-staged, ensuring no stale records from prior runs interfere with the incoming data.

Question 3

What is the purpose of the HUB_STATE_IND column set on records in the Informatica MDM staging table?

Accepted Answer

Tracks the processing state of a staged record (pending, active, deleted)

Answer

HUB_STATE_IND marks the lifecycle state of a staged record, such as whether it is pending processing, has been loaded, or represents a logical delete from the source.

Question 4

In Informatica MDM, what does a HUB_STATE_IND value of '1' typically represent for a staging record?

Accepted Answer

The record is new and pending load into the base object

Answer

A HUB_STATE_IND of 1 indicates the record is new (pending) and has not yet been promoted to the base object by the load job.

Question 5

Which Informatica MDM feature allows a source system to signal that a previously loaded record should be logically removed from the hub during the next load?

Accepted Answer

Delete indicator on the staging record

Answer

A delete indicator (or HUB_STATE_IND set to indicate deletion) on a staging record tells the load job to logically remove or deactivate the corresponding base object record.

(MDM) Informatica Master Data Management Certification Practice Test

(MDM) Informatica Master Data Management Certification Practice Test

MDM Staging and Loading 4