PR000005 practice question 15 of 25

Which two IDQ transformations can use parameters? Choose 2 answers

Full set: 140 questions
Answer options
A: Comparison
B: Decision Correct answer
C: Case converter
D: Address Validation Correct answer
E: Labeller
Correct Answer:
B. Decision; D. Address Validation
Explanation

In Informatica Data Quality (IDQ), parameters allow for greater flexibility and reusability of mappings by enabling the modification of values at runtime. The Decision transformation can use parameters within its expression editor to dynamically change the conditions for routing data. This is useful for altering business logic without redesigning the mapping. The Address Validation transformation has numerous configurable properties, such as reference data file locations, license keys, and processing options, which can be assigned parameters. This is crucial for managing different environments (e.g., development, testing, production) where file paths and configurations vary.

Why Incorrect

A. Comparison: The core logic, including the columns to be compared and the comparison criteria, is configured statically at design time and does not support parameterization.
C. Case converter: The primary property of this transformation, the case to convert to (e.g., Upper, Lower), is a fixed selection and cannot be dynamically assigned using a parameter.
E. Labeller: The rules and labels within the Labeller transformation are defined directly in its properties during development and are not designed to be driven by runtime parameters.

References

1. Informatica Data Quality 10.4.0, Developer Transformation Guide, "Decision Transformation," Page 127: "You can enter an expression that includes constants, ports, built-in functions, and parameters." This statement explicitly confirms that parameters can be used in the Decision transformation's core logic.

2. Informatica Data Quality 10.4.0, Developer Transformation Guide, "Address Validator Transformation," Page 40: "You can assign a parameter to an Address Validator transformation property. You can assign a parameter to any property that you can edit." The guide further lists properties like "License Key" and "Reference Data Location" as examples that can be parameterized.

3. Informatica 10.2.0, Data Quality User Guide, "Parameters," Chapter 13, Page 279: "You can use parameters to define values that you want to change each time you run a mapping, profile, or workflow... For example, you can create a parameter for the reference data file directory for an Address Validator transformation." This provides a general principle and a specific example supporting the parameterization of the Address Validation transformation.

Scroll to Top