PR000005 practice question 10 of 25

Which are correct statements for IDQ grouping and matching?Choose 2 answers

Full set: 140 questions
Answer options
A: IDQ field level matching does not utilize grouping
B: When field level matching is performed, the records within each group will be compared against each other Correct answer
C: When field level matching is performed, matching will be performed across multiple groups in a single match transformation.
D: When field level matching is performed, matching will not be performed across groups, therefore it is imperative grouping is performed on a complete and accurate field(s) Correct answer
Correct Answer:
B. When field level matching is performed, the records within each group will be compared against each other; D. When field level matching is performed, matching will not be performed across groups, therefore it is imperative grouping is performed on a complete and accurate field(s)
Explanation

The Informatica Data Quality (IDQ) Match transformation operates in a two-phase process. First, it partitions the entire dataset into smaller, manageable subsets called groups based on the defined group key columns. This is the grouping phase. Second, it performs the detailed comparison and matching logic, such as field-level matching, exclusively on the records within each group. Records from different groups are never compared against each other in a single Match transformation. Consequently, the accuracy and completeness of the fields used for the group key are critical to ensure that potential duplicates are placed in the same group and are not missed by the matching process.

Why Incorrect

A. IDQ field level matching does not utilize grouping: This is incorrect. The grouping phase is a fundamental and mandatory prerequisite for any matching strategy, including field-level matching, within the IDQ Match transformation to ensure performance.
C. When field level matching is performed, matching will be performed across multiple groups in a single match transformation: This is incorrect. The core design of the Match transformation is to restrict comparisons to records within the same group, not across different groups.

References

1. Informatica Data Quality 10.5 Transformation Guide, Chapter 20: "Match Transformation", Section: "Match Transformation Overview", Page 338.

"The Match transformation identifies duplicate records in your source data. The transformation groups data based on the columns that you define as group keys. It then compares the records in each group based on the match columns that you define." This statement confirms that grouping is used (refuting A) and that comparisons happen within each group (supporting B).

2. Informatica Data Quality 10.5 Transformation Guide, Chapter 20: "Match Transformation", Section: "Grouping Data", Page 340.

"The Match transformation compares records only within the groups that it creates. It does not compare records from different groups. For this reason, the choice of group key columns is critical to the success of the match analysis. If you select a group key that contains inaccurate or incomplete data, the transformation may place records that are duplicates into different groups. The transformation will not identify the records as duplicates." This passage directly supports option D and refutes option C.

Scroll to Top