MDM Hub Configuration and Management 3 — Questions and Answers
Question 1: In Informatica MDM Hub, what does a trust score determine?
- The reliability of a source system's contributed value when populating a golden record field (Correct answer)
- The probability that two records are a match during the match process
- The overall data quality score assigned to a golden record
- The number of source systems that have provided a value for a field
Correct answer: The reliability of a source system's contributed value when populating a golden record field
Trust scores represent the configured reliability of a source system's data for a specific column, controlling which source value wins in the golden record.
Question 2: Which MDM Hub match type compares two records using phonetic, edit-distance, or other approximate algorithms?
- Exact match
- Fuzzy match (Correct answer)
- Deterministic match
- Primary key match
Correct answer: Fuzzy match
Fuzzy matching uses probabilistic algorithms like Jaro-Winkler or Soundex to find records that are similar but not identical, catching typos and variations.
Question 3: What is the purpose of a 'match rule set' in MDM Hub?
- A collection of individual match rules evaluated together to determine if two records should be merged (Correct answer)
- A schedule that defines when the automated match batch job runs
- A threshold configuration that sets the minimum trust score for a source
- A mapping between landing columns and staging columns
Correct answer: A collection of individual match rules evaluated together to determine if two records should be merged
A match rule set groups related match rules and applies them sequentially or in combination to decide whether two candidate records represent the same real-world entity.
Question 4: In MDM Hub's trust framework, what does 'trust decay' mean?
- The reduction in a source system's trust score over time as data ages (Correct answer)
- The decrease in match confidence when few columns are compared
- The removal of a source record when its originating system is decommissioned
- The downgrading of a golden record's quality flag after an unmerge
Correct answer: The reduction in a source system's trust score over time as data ages
Trust decay allows administrators to configure a time-based reduction in trust so that older source values are less likely to overwrite more recent contributions.
Question 5: When two records are merged in MDM Hub, what happens to their individual cross-reference records?
- They are deleted and replaced by a single new cross-reference record
- They are retained and linked to the surviving golden record's ROWID_OBJECT (Correct answer)
- They are moved to an archive table and purged after 90 days
- They are flagged as duplicates but kept in separate base object rows
Correct answer: They are retained and linked to the surviving golden record's ROWID_OBJECT
After a merge, all contributing cross-reference records point to the winning golden record, preserving the lineage of every source system's contribution.
Question 6: Which Hub Console tool is used to review, accept, or reject match candidates before a merge is finalized?
- Data Steward workbench
- Merge Manager (Correct answer)
- Match Analysis Report
- Schema Validator
Correct answer: Merge Manager
Merge Manager provides a UI where data stewards can inspect identified duplicates and decide to merge, link, or reject each match candidate.
Question 7: What is an 'auto-merge' threshold in MDM Hub match configuration?
- A minimum match score above which records are merged automatically without human review (Correct answer)
- The maximum number of records the system will merge in a single batch job run
- A trust score level that triggers an automatic re-cleanse of source data
- A confidence level below which records are silently discarded
Correct answer: A minimum match score above which records are merged automatically without human review
The auto-merge threshold sets the minimum match score at which MDM Hub merges records programmatically, bypassing the manual Merge Manager review queue.
In Informatica MDM Hub, what does a trust score determine?