MDM Staging and Loading 3

Question 1

Which Informatica MDM configuration controls how many records are committed to the database in a single transaction during a load job?

Accepted Answer

Batch size (commit interval)

Answer

The commit interval (batch size) determines how many records are inserted or updated per database transaction, balancing throughput against memory usage.

Question 2

After running a stage job, a data steward notices the _STG table is populated but the base object remains empty. What is the most likely cause?

Accepted Answer

The load job has not been executed yet

Answer

Staging and loading are separate jobs; populating the _STG table only completes the stage phase, and the load job must run separately to move records into the base object.

Question 3

What does the 'promote' operation accomplish within the Informatica MDM load process?

Accepted Answer

It moves cleansed and validated staging records into the base object table

Answer

Promotion is the step within the load job where records that passed cleansing and validation are written from staging into the base object, making them part of the hub.

Question 4

In Informatica MDM, which scenario would trigger a reject during the load job rather than the stage job?

Accepted Answer

A record that violates a uniqueness constraint defined on the base object

Answer

Base object-level uniqueness constraint violations are detected at load time when MDM attempts to insert the record into the hub, not at the earlier stage validation phase.

Question 5

When an Informatica MDM landing table is used instead of a direct staging table approach, what is the landing table's role?

Accepted Answer

It acts as a temporary holding area for raw inbound data before the stage job processes it

Answer

Landing tables serve as the initial drop zone where source system data arrives, and the stage job then reads from landing tables to populate the formal staging tables.

(MDM) Informatica Master Data Management Certification Practice Test

(MDM) Informatica Master Data Management Certification Practice Test

MDM Staging and Loading 3