Match and Merge Rules Flashcards
6 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 6 Match and Merge Rules flashcards as text
A company is implementing Informatica MDM to consolidate customer data from three different source systems. The data contains variations in spelling and format for customer names and addresses. Which match strategy should be configured in the base object to identify these potential duplicates effectively?
Answer: Fuzzy Match
Fuzzy matching is the appropriate strategy because it is designed to identify records that are similar but not identical. It can handle variations like misspellings, phonetic differences, and abbreviations, which are common in customer data from multiple sources.
In a Match Rule Set configuration, what is the primary function of the 'Search Level' property?
Answer: To determine the number of match candidates returned during the search phase.
The Search Level property in a Match Rule Set is used to control how many potential match candidates are returned by the search phase of the match process. Options like 'Narrow,' 'Typical,' and 'Exhaustive' allow administrators to balance performance with the thoroughness of the match search.
A data steward is configuring a match rule and wants to ensure that two records are automatically merged only if their Social Security Numbers (SSN) are identical. For all other potential matches, a manual review is required. Which of the following configurations would achieve this?
Answer: A single Exact Match rule on the SSN column with the 'Auto' property enabled.
An Exact Match rule ensures that only records with identical values in the specified column (SSN) are considered a match. Enabling the 'Auto' property for this specific rule instructs the Auto Merge batch job to automatically merge the records that satisfy this rule, while other matches would be queued for manual review.
When configuring match rules in Informatica MDM, which component defines the base object and the relationships to be traversed to find data for matching?
Answer: Match Path
The Match Path component is used to specify the base object that provides the data for matching and to define the traversal of relationships (parent-to-child or child-to-parent) across multiple base objects or within a single base object.
Which of the following statements accurately describes the relationship between Match Rules and Match Rule Sets?
Answer: A Match Rule Set is a logical grouping of one or more Match Rules, and only one Match Rule Set can be active at a time for a base object.
A Match Rule Set is a collection of individual Match Rules that work together to identify duplicates for a base object. While multiple rule sets can be defined, only one can be active at any given time for that base object.
During the merge process, the MDM Hub needs to decide which cell-level value to preserve in the golden record when matched records have conflicting data. Which rule set governs this survivorship logic?
Answer: Trust and Survivorship Rules
Trust and Survivorship rules determine how the final, consolidated record (golden record) is created. Trust scores are assigned to source systems, and survivorship rules use these scores (or other logic like 'most recent') to decide which attribute value from which source record 'survives' to become part of the master record.