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
In Informatica MDM, which log or table should an administrator first consult to diagnose why records are not appearing in the base object after a load job completes?
Answer: The reject/error table and batch job log
The reject/error table captures records that failed validation or constraint checks, and the batch job log records execution details and error messages, making them the first diagnostic resources.
When an Informatica MDM batch group is configured with a 'Stage and Load' job sequence, what is the risk of running multiple batch groups concurrently against the same base object?
Answer: Delta detection results can conflict, leading to missed or duplicated record processing
Running concurrent stage/load jobs against the same base object can cause race conditions where delta detection windows overlap, resulting in records being skipped or processed twice.
Which Informatica MDM concept describes the process of writing source record attribute values into the XREF table rather than directly overwriting the base object during load?
Answer: Cross-referencing
Cross-referencing stores each source system's attribute values in the XREF table, preserving the original source data while allowing survivorship rules to compute the base object's best value.
In Informatica MDM, what does the term 'initial load' specifically refer to in the context of staging and loading?
Answer: The first-time full population of the hub from all source systems
An initial load is the first end-to-end full load of all source data into a newly configured MDM hub, establishing the baseline set of records from which incremental loads continue.
Which Informatica MDM Hub component is responsible for executing the stage and load batch jobs on a schedule?
Answer: Hub Server with batch framework / ORS batch API
The MDM Hub Server exposes a batch framework (ORS batch API) that executes stage, load, match, and merge jobs, either on demand or via external schedulers.
When configuring mappings for a landing table to staging table transition in Informatica MDM, which field mapping is mandatory to enable proper delta detection?
Answer: PKEY_SRC_OBJECT (source primary key)
PKEY_SRC_OBJECT must be mapped because it carries the source system's primary key, which MDM uses during delta detection to compare incoming records against previously staged data.
In Informatica MDM, what is the purpose of the 'Tokenize' job that sometimes precedes the match job in a batch group sequence?
Answer: It generates match tokens from key fields to enable efficient fuzzy matching
The Tokenize job pre-computes match tokens (standardized, phonetic, or algorithmic representations) from key attributes, which the match engine then uses to efficiently find candidate duplicate pairs.