PR000005 practice question 24 of 25

What transformation would you use to standardize data using a reference table?

Full set: 140 questions
Answer options
A: Labeler
B: Decision
C: Standardizer Correct answer
D: Parser
Correct Answer:
C. Standardizer
Explanation

The Standardizer transformation in Informatica Data Quality is specifically designed to cleanse and standardize data values by comparing them against a reference table. This transformation takes an input value, looks for it or its variants within the specified reference table, and replaces it with the corresponding "standard" value defined in that table. This process ensures data consistency and conforms the data to a predefined standard, which is the exact requirement stated in the question.

Why Incorrect

A. Labeler: The Labeler transformation is used to classify or categorize data by identifying patterns, not to standardize values against a reference table.
B. Decision: The Decision transformation applies conditional logic (if/then/else) to route or modify data, but it is not the dedicated tool for standardization using reference tables.
D. Parser: The Parser transformation deconstructs data from a single field into multiple components based on tokens and patterns, such as splitting a full name into first and last names.

References

1. Informatica Data Quality 10.5 - Developer Transformation Guide, Chapter 38: "Standardizer Transformation", Page 515.

The guide states, "The Standardizer transformation standardizes data values in one or more input ports. The transformation uses a reference table that contains the standard data values and any variant forms of the data. The Standardizer transformation compares the input data with the variant data in the reference table and replaces the variant data with the standard value."

2. Informatica Data Quality 10.4.0 - Developer Transformation Guide, Chapter 37: "Standardizer Transformation", Page 499.

This earlier version provides the same core definition: "Use the Standardizer transformation to standardize data values in one or more input ports. The transformation uses a reference table that contains the standard data values and any variant forms of the data."

3. Informatica University - Data Quality 10: Developer, Specialist Certification Preparation, Module: "Data Standardization".

Courseware for the PR000005 exam explicitly details the use of the Standardizer transformation with reference tables as the primary method for standardizing inconsistent data values into a preferred format. It contrasts this with the Parser, which is for structuring data, and the Labeler, which is for classifying data.

Scroll to Top