PR000005 practice question 24 of 25
What transformation would you use to standardize data using a reference table?
Full set: 140 questionsThe 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.
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.
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.
Keep practicing
Take the free PR000005 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PR000005 practice questions
- Question 1When you select Suggestion List mode what statement is true?
- Question 2How much data can DQA handle?
- Question 3What is the primary purpose of grouping data?
- Question 4Which definition describes Column Profiling?
- Question 5Which parameter function is supported in IDQ 9.1?
- Question 6Which of the following is not true when it comes to creating and updating Reference Table…
