Match and Merge Rules 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 Match and Merge Rules flashcards as text
In Informatica MDM, what is a 'match path component' used for?
Answer: To specify the relationship traversal path when matching on related entity data
Match path components define how MDM traverses foreign-key relationships to retrieve related data (e.g., address records) for use in cross-object match column comparisons.
Which setting in an Informatica MDM match rule set defines the minimum score a record pair must achieve to be considered a potential duplicate?
Answer: Match Threshold
The Match Threshold is the lower bound score; record pairs scoring at or above it are treated as potential duplicates and routed to either auto-merge or manual review.
What is the effect of setting a match column's 'Null Match' property to 'Match on Null' in Informatica MDM?
Answer: Two records both having null in that column are treated as matching on that column
When 'Match on Null' is configured, two null values in the same match column are treated as equivalent, contributing positively to the match score.
In Informatica MDM, what is an 'exclusive match rule'?
Answer: A rule that, when satisfied, prevents the matched records from being merged regardless of score
An exclusive match rule, when its criteria are met, excludes the record pair from being merged — useful for records that share attributes but must remain distinct (e.g., same-name family members at the same address).
During an Informatica MDM batch match job, what is the purpose of the 'tokenize' stage?
Answer: To generate match key tokens from record data used to retrieve match candidates
The tokenize stage generates match key tokens (e.g., phonetic or exact keys) and stores them in match key tables so candidates can be efficiently retrieved during the match stage.
What does the Informatica MDM 'Unmerge' operation accomplish?
Answer: Separates a previously merged record, restoring contributing records as independent base object entries
Unmerge reverses a prior merge by detaching the cross-reference records from the golden record and promoting them back to independent base object records with their own ROWIDs.
In Informatica MDM match configuration, what does increasing the 'Match Column Weight' of a column achieve?
Answer: It increases the maximum possible match score contribution from that column relative to others
A higher weight for a match column means that column contributes more to the total match score, making it more influential in determining whether two records are duplicates.