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

Delta Detection is the specific feature in Informatica MDM designed for this purpose. When enabled, the Stage job compares the records in the landing table with a snapshot of the previous landing table's data to identify and process only new or modified records. [1, 5]

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

The Stage process is the second step in the three-layered batch architecture. Its main role is to transfer data from the landing tables to the staging tables. During this transfer, it applies mappings and cleanse functions to standardize and prepare the data for the Load process. [2, 6]

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

The Audit Trail property, when enabled on a staging table, creates an associated _RAW table. This table stores a copy of the raw, unclean data from the landing table for each stage job run, serving as a historical audit log. [1, 3, 5]

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

The Load process moves data from a staging table to the target Base Object. Key steps in this process include calculating trust scores for columns where trust is enabled, performing lookups, running validation rules, and then inserting or updating records in the Base Object and its associated XREF table. [4]

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

Mappings are a core component of the Stage process. They define how data flows from a source column in a landing table to a target column in a staging table. Mappings are also where cleanse functions are applied to standardize or transform the data during this movement. [5, 6]

(MDM) Informatica Master Data Management Certification Practice Test

(MDM) Informatica Master Data Management Certification Practice Test

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