MDM Hub Configuration and Management 2 — Questions and Answers
Question 1: In Informatica MDM Hub, what is the purpose of the Schema Manager?
- To define and manage the physical and logical structure of the Hub Store (Correct answer)
- To schedule batch jobs for data loading
- To configure user roles and permissions
- To monitor the health of the Hub Server
Correct answer: To define and manage the physical and logical structure of the Hub Store
Schema Manager is the Hub Console tool used to define base objects, landing tables, staging tables, and their relationships within the Hub Store.
Question 2: Which table type in Informatica MDM Hub temporarily holds raw source data before it is processed and moved to the staging area?
- Base Object table
- Landing table (Correct answer)
- Cross-reference table
- Lookup table
Correct answer: Landing table
Landing tables receive raw data from source systems and act as the entry point before cleanse and load processes move data to staging tables.
Question 3: What does the consolidation indicator value 'U' represent in a Hub cross-reference record?
- Unmerged record awaiting processing (Correct answer)
- Undergoing match processing
- Unique record that bypassed matching
- Updated record pending re-evaluation
Correct answer: Unmerged record awaiting processing
A consolidation indicator of 'U' marks a cross-reference record as unmerged, meaning it has not yet been matched and consolidated into a golden record.
Question 4: When configuring a base object in MDM Hub, what is the significance of the 'Primary Key Match Column' setting?
- It defines which column uniquely identifies records within the base object for exact-match deduplication (Correct answer)
- It specifies the column used for fuzzy matching algorithms
- It determines the sort order for golden record display
- It sets the column that stores trust scores
Correct answer: It defines which column uniquely identifies records within the base object for exact-match deduplication
The Primary Key Match Column identifies records uniquely so MDM Hub can perform exact (deterministic) matching and link source records to existing golden records.
Question 5: In the MDM Hub console, what is a 'Package' used for?
- To bundle and deploy Hub configuration to another environment
- To define a reusable set of columns returned from a base object for SIF queries (Correct answer)
- To group batch jobs into a scheduled workflow
- To archive older versions of golden records
Correct answer: To define a reusable set of columns returned from a base object for SIF queries
A Package in MDM Hub defines a named subset of columns from a base object that can be queried through the Services Integration Framework (SIF).
Question 6: Which MDM Hub configuration controls how long a staging record is retained before it is eligible for cleanup?
- Delta detection threshold
- Staging table retention period (Correct answer)
- Trust decay rate
- Merge history window
Correct answer: Staging table retention period
The staging table retention period setting determines how many days processed staging records are kept before the system purges them during maintenance.
Question 7: What is the role of the 'Rowid Object' column automatically created in every MDM Hub base object?
- It stores the source system's primary key for each record
- It serves as the system-generated unique identifier for each golden record (Correct answer)
- It tracks the last user who modified the record
- It holds the encrypted version of the match key
Correct answer: It serves as the system-generated unique identifier for each golden record
ROWID_OBJECT is an MDM Hub-generated surrogate key that uniquely identifies each golden record in a base object table.
MDM Hub Configuration and Management 2
In Informatica MDM Hub, what is the purpose of the Schema Manager?