Staging and Loading Flashcards
7 cards from real MDM practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Staging and Loading flashcards as text
Which Informatica MDM configuration controls how many records are committed to the database in a single transaction during a load job?
Answer: Batch size (commit interval)
The commit interval (batch size) determines how many records are inserted or updated per database transaction, balancing throughput against memory usage.
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?
Answer: The load job has not been executed yet
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.
What does the 'promote' operation accomplish within the Informatica MDM load process?
Answer: It moves cleansed and validated staging records into the base object table
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.
In Informatica MDM, which scenario would trigger a reject during the load job rather than the stage job?
Answer: A record that violates a uniqueness constraint defined on the base object
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.
When an Informatica MDM landing table is used instead of a direct staging table approach, what is the landing table's role?
Answer: It acts as a temporary holding area for raw inbound data before the stage job processes it
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.
Which MDM Hub job is responsible for populating the _STG table from the landing table?
Answer: Stage job
The stage job reads data from landing (or external sources), applies cleanse functions, and writes results into the _STG staging table.
In Informatica MDM, what is the significance of the LAST_UPDATE_DATE column in the staging table?
Answer: It is used by delta detection to identify records modified since the last successful stage run
LAST_UPDATE_DATE is evaluated during delta detection to determine which source records have changed since the previous staging run, enabling efficient incremental processing.