โ† All MDM Flashcard Decks

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
  1. What is the difference between a 'manual merge' and an 'auto-merge' in Informatica MDM?

    Answer: Manual merge requires a data steward to approve the merge in a workflow; auto-merge occurs automatically when the score exceeds the auto-merge threshold

    Auto-merge fires automatically when the match score exceeds the auto-merge threshold, while manual merge routes the potential duplicate pair to a data steward via Merge Manager for human approval.

  2. In Informatica MDM, which table stores the cross-reference records that link a golden record to its contributing source system records?

    Answer: _XREF (cross-reference table)

    The _XREF table for each base object stores cross-reference rows that associate each source system record with the golden record it contributes to.

  3. What is the effect of enabling 'Allow Remerge' on an Informatica MDM base object?

    Answer: It allows batch match to re-evaluate previously auto-merged records for additional merges

    When Allow Remerge is enabled, the batch match process can merge records that have already been auto-merged, enabling further consolidation as new data arrives.

  4. In Informatica MDM, what is a 'survivorship rule' and when is it applied?

    Answer: A rule that determines which source system's value survives when the golden record is assembled after a merge

    Survivorship rules (part of trust configuration) determine which source system cell value 'wins' and is written to the golden record when records from multiple sources are merged.

  5. Which Informatica MDM match column match type is best suited for comparing fields like Social Security Numbers that must match exactly?

    Answer: Exact

    Exact match type requires character-for-character equality between the two values, making it appropriate for structured identifiers like SSNs, account numbers, or dates.

  6. During Informatica MDM real-time match (SIF ExecuteMatchAndMerge), which match rule sets are evaluated?

    Answer: Only rule sets that have the 'Enable Real-Time Match' flag set to true

    Only match rule sets explicitly configured with 'Enable Real-Time Match' set to true are evaluated during real-time SIF match operations.

  7. What is the function of the 'Minimum Match Score' parameter in the Informatica MDM SIF SearchMatch API call?

    Answer: It filters out candidate records whose match score falls below the specified value before returning results to the caller

    Minimum Match Score acts as a post-scoring filter in SearchMatch, returning only candidate records that achieve at least the specified score to the calling application.