MDM - Informatica Master Data Management Data Staging and Loading Questions and Answers

Question 1

An MDM developer is configuring a batch job to load customer data from a source system.
The source provides a full data file every night, but the developer needs to ensure that only records that are new or have changed since the last run are processed to improve efficiency.
Which staging table property must be enabled?

Accepted Answer

Delta Detection

Answer

Audit Trail

Answer

Enable Distinct

Answer

Force Update

Question 2

What is the primary function of the Stage process in the Informatica MDM batch data flow?

Accepted Answer

To move cleansed and standardized data from a landing table to a corresponding staging table.

Answer

To consolidate matched records into a single golden record.

Answer

To hold the final, trusted master data records for consumption by downstream systems.

Answer

To initially receive raw, unprocessed batch data from various source systems.

Question 3

A compliance requirement mandates that a complete, unaltered history of all data received from a specific source system must be retained for auditing purposes, exactly as it appeared in the landing table at the time of each stage job run. How can this be achieved in Informatica MDM?

Accepted Answer

Enable the Audit Trail (RAW) property on the staging table.

Answer

Enable History for the Base Object.

Answer

Configure Delta Detection with a long retention period.

Answer

Use a post-load user exit to copy data to a separate archive.

Question 4

During the Load process in Informatica MDM, which of the following actions is performed?

Accepted Answer

Calculating trust scores and running validation rules before inserting/updating a Base Object.

Answer

Applying cleanse functions to standardize source data.

Answer

Generating match tokens for identifying duplicate records.

Answer

Moving data from a source file into a Landing table.

Question 5

In the context of an Informatica MDM Stage job, what is the purpose of Mappings?

Accepted Answer

To define the movement and transformation of data from landing table columns to staging table columns.

Answer

To define the rules for consolidating records into a golden copy.

Answer

To specify which records from the landing table should be rejected.

Answer

To configure the physical relationship between a Base Object and its XREF table.

Question 6

Which statement correctly describes the roles of Landing, Staging, and Base Object tables in the Informatica MDM Hub architecture?

Accepted Answer

Landing tables are for initial data reception, Staging tables are for cleansing and standardizing source-specific data, and Base Objects hold the consolidated master records.

Answer

Landing tables hold cleansed data, Staging tables hold raw data, and Base Objects hold duplicates.

Answer

Landing tables hold master data, Staging tables hold historical data, and Base Objects hold transactional data.

Answer

Landing tables store rejected records, Staging tables are for source-to-target mappings, and Base Objects are temporary work tables.