MDM Architecture and Datamodel 2 — Questions and Answers
Question 1: In Informatica MDM Hub, what is the purpose of the 'Schema Manager' tool?
- To define and manage the physical schema of the ORS database
- To create and manage landing tables, staging tables, and base objects (Correct answer)
- To configure Cleanse Match Servers
- To manage user roles and access permissions
Correct answer: To create and manage landing tables, staging tables, and base objects
Schema Manager is used to create and manage the structural components of the MDM Hub store, including landing tables, staging tables, and base objects.
Question 2: Which MDM Hub component is responsible for comparing records to identify potential duplicates?
- Cleanse Functions
- Match Column
- Match Rule Set (Correct answer)
- Consolidation Manager
Correct answer: Match Rule Set
A Match Rule Set defines the combination of match rules and columns used to compare records and identify potential duplicates in MDM Hub.
Question 3: What does the 'Rowid Object' column represent in an MDM Hub base object table?
- A foreign key referencing the parent base object
- A unique system-generated identifier for each master record (Correct answer)
- The source system's original record key
- A hash value used for change detection
Correct answer: A unique system-generated identifier for each master record
The Rowid Object is a system-generated unique identifier assigned to every master record in a base object table within MDM Hub.
Question 4: In the MDM Hub trust framework, what happens when two source records have the same trust score for a given field?
- The most recently loaded record wins
- The record with the higher source system priority wins (Correct answer)
- MDM Hub flags the record for manual review
- The field value is left NULL
Correct answer: The record with the higher source system priority wins
When trust scores are equal, MDM Hub uses the configured source system priority order to determine which value populates the best version of the truth.
Question 5: Which table type in MDM Hub temporarily holds raw data before it is cleansed and matched?
- Base Object table
- Cross-reference table
- Landing table (Correct answer)
- Relationship table
Correct answer: Landing table
Landing tables are the initial destination for raw source data loaded into MDM Hub before any cleansing or matching occurs.
Question 6: What is the role of the 'Consolidation Indicator' (CONSOLIDATION_IND) column in MDM Hub base objects?
- Tracks which source contributed the golden record value
- Indicates the current consolidation state of a record in the merge/unmerge lifecycle (Correct answer)
- Stores the confidence score of the match process
- Flags records that have been manually edited by a steward
Correct answer: Indicates the current consolidation state of a record in the merge/unmerge lifecycle
The CONSOLIDATION_IND column tracks where a record stands in the MDM Hub processing pipeline, such as whether it is new, matched, consolidated, or marked for review.
Question 7: In Informatica MDM Hub's hub architecture, what is an 'Operational Reference Store' (ORS)?
- A read-only analytical data warehouse fed by MDM Hub
- A self-contained database schema storing all hub metadata and master data for a domain (Correct answer)
- A staging area external to MDM Hub used by ETL tools
- A cache layer that speeds up match processing
Correct answer: A self-contained database schema storing all hub metadata and master data for a domain
An ORS is an independent database schema within MDM Hub that contains all metadata configurations, staging objects, and master data records for a specific data domain.
MDM Architecture and Datamodel 2
In Informatica MDM Hub, what is the purpose of the 'Schema Manager' tool?