MDM Match and Merge Rules 2

Question 1

In Informatica MDM, what is the purpose of a 'fuzzy match' key?

Accepted Answer

To generate phonetic or approximate keys that allow near-duplicate detection

Answer

To perform exact string comparisons between records

Answer

To encrypt sensitive data before matching

Answer

To create a unique primary key for each base object record

Question 2

Which Informatica MDM component is responsible for executing the match process against a set of records?

Accepted Answer

Match Server (cmxmatch)

Answer

Hub Server

Answer

Cleanse Server

Answer

SIF Server

Question 3

What does the 'Consolidation Indicator' (CONSOLIDATION_IND) on a base object record signify?

Accepted Answer

The merge state of the record — for example, 'R' for merged, 'B' for consolidated

Answer

Whether the record was loaded via a batch or real-time process

Answer

The trust level assigned to the source system

Answer

The number of cross-references linked to the record

Question 4

In an Informatica MDM match rule set, what is the role of a 'primary match column'?

Accepted Answer

It is the first column evaluated; records must match on it before additional columns are assessed

Answer

It overrides all other match columns and alone determines the match score

Answer

It stores the final merged value for that attribute

Answer

It designates the column used exclusively for exact-match comparisons

Question 5

When configuring a match rule in Informatica MDM Hub Console, what does the 'Match Column Search Level' property control?

Accepted Answer

How broadly or narrowly MDM searches for candidate records using match keys

Answer

The maximum number of records returned by a match search

Answer

The order in which match rules are evaluated within a rule set

Answer

The minimum number of matching columns required to confirm a match

Question 6

What happens when two records exceed the 'Auto-Merge Threshold' in Informatica MDM?

Accepted Answer

They are automatically merged without human intervention

Answer

They are flagged for manual review in the Merge Manager

Answer

They are deleted from the base object

Answer

They are sent back to the source system for correction

Question 7

In Informatica MDM, which merge style produces a single 'golden record' by applying cell-level trust rules across all contributing source records?

Accepted Answer

Trust-based (best-of-breed) merge

Answer

Source System Override merge

Answer

Last-write-wins merge

Answer

Manual merge