ICC Mappings & Transformations 2 — Questions and Answers
Question 1: What is the purpose of the Router transformation in Informatica Cloud?
- To join two separate data streams based on a common key
- To route rows to different output groups based on multiple specified conditions (Correct answer)
- To aggregate data and compute group-level statistics
- To sort records before writing to multiple targets
Correct answer: To route rows to different output groups based on multiple specified conditions
The Router transformation evaluates each row against multiple conditions and routes rows to different output groups based on which condition is satisfied, similar to a CASE statement.
Question 2: What does the Aggregator transformation do in Informatica Cloud?
- Generates new rows from a single input row of nested data
- Performs calculations such as SUM, COUNT, and AVG on groups of rows (Correct answer)
- Routes data to multiple targets simultaneously based on conditions
- Converts hierarchical data formats into flat relational format
Correct answer: Performs calculations such as SUM, COUNT, and AVG on groups of rows
The Aggregator transformation performs aggregate calculations on groups of rows, enabling computations such as SUM, COUNT, AVG, MIN, and MAX similar to SQL GROUP BY queries.
Question 3: In Informatica Cloud, mapping parameters are primarily used to:
- Define physical connection properties to source and target systems
- Store values that can be passed at runtime to make mappings reusable across environments (Correct answer)
- Specify the sort order for output data written to the target
- Define error handling and recovery behavior within a mapping
Correct answer: Store values that can be passed at runtime to make mappings reusable across environments
Mapping parameters store values that can be overridden at runtime, making the same mapping reusable across different environments or configurations without modifying the mapping design.
Question 4: What is the Hierarchy Builder transformation used for in Informatica Cloud?
- To flatten hierarchical JSON or XML data into a relational format
- To construct hierarchical or nested data structures like JSON or XML from flat relational data (Correct answer)
- To create parent-child relationships between database tables in the target
- To merge multiple flat files into a single hierarchical output file
Correct answer: To construct hierarchical or nested data structures like JSON or XML from flat relational data
The Hierarchy Builder transformation constructs hierarchical data structures such as JSON or XML from flat relational input data, enabling complex document format output.
Question 5: In Informatica Cloud Data Integration, what distinguishes a connected lookup from an unconnected lookup?
- A connected lookup requires an active network connection while an unconnected lookup works offline
- A connected lookup is part of the data flow pipeline and returns values directly, while an unconnected lookup is called via an expression (Correct answer)
- A connected lookup queries external APIs while an unconnected lookup uses local cache
- A connected lookup supports multiple return values while an unconnected lookup returns only one
Correct answer: A connected lookup is part of the data flow pipeline and returns values directly, while an unconnected lookup is called via an expression
A connected lookup is directly integrated into the mapping pipeline and passes return values to the next transformation, whereas an unconnected lookup is invoked using the :LKP expression within another transformation.
Question 6: What is the Sequence Generator transformation used for in Informatica Cloud?
- To sort records into a numerically ascending sequential order
- To generate unique numeric sequence values for each row processed in a mapping (Correct answer)
- To create alphabetically sequenced output file names for batch exports
- To detect and flag out-of-sequence records in the data stream
Correct answer: To generate unique numeric sequence values for each row processed in a mapping
The Sequence Generator transformation produces unique numeric sequence values for each row, commonly used to generate surrogate keys or unique record identifiers for target tables.
Question 7: In Informatica Cloud, what is a Rank transformation primarily used for?
- To sort all records in the dataset in a specified order
- To select a specified number of top or bottom records based on a ranking field (Correct answer)
- To deduplicate records and keep only the highest-ranked version
- To route records to different output groups based on their rank score
Correct answer: To select a specified number of top or bottom records based on a ranking field
The Rank transformation selects the top or bottom N records based on a specified field value, enabling use cases such as finding the top 10 customers by revenue.
ICC Mappings & Transformations 2
What is the purpose of the Router transformation in Informatica Cloud?