ICC Mappings & Transformations 2

Question 1

What is the purpose of the Router transformation in Informatica Cloud?

Accepted Answer

To route rows to different output groups based on multiple specified conditions

Answer

To join two separate data streams based on a common key

Answer

To aggregate data and compute group-level statistics

Answer

To sort records before writing to multiple targets

Question 2

What does the Aggregator transformation do in Informatica Cloud?

Accepted Answer

Performs calculations such as SUM, COUNT, and AVG on groups of rows

Answer

Generates new rows from a single input row of nested data

Answer

Routes data to multiple targets simultaneously based on conditions

Answer

Converts hierarchical data formats into flat relational format

Question 3

In Informatica Cloud, mapping parameters are primarily used to:

Accepted Answer

Store values that can be passed at runtime to make mappings reusable across environments

Answer

Define physical connection properties to source and target systems

Answer

Specify the sort order for output data written to the target

Answer

Define error handling and recovery behavior within a mapping

Question 4

What is the Hierarchy Builder transformation used for in Informatica Cloud?

Accepted Answer

To construct hierarchical or nested data structures like JSON or XML from flat relational data

Answer

To flatten hierarchical JSON or XML data into a relational format

Answer

To create parent-child relationships between database tables in the target

Answer

To merge multiple flat files into a single hierarchical output file

Question 5

In Informatica Cloud Data Integration, what distinguishes a connected lookup from an unconnected lookup?

Accepted Answer

A connected lookup is part of the data flow pipeline and returns values directly, while an unconnected lookup is called via an expression

Answer

A connected lookup requires an active network connection while an unconnected lookup works offline

Answer

A connected lookup queries external APIs while an unconnected lookup uses local cache

Answer

A connected lookup supports multiple return values while an unconnected lookup returns only one

Question 6

What is the Sequence Generator transformation used for in Informatica Cloud?

Accepted Answer

To generate unique numeric sequence values for each row processed in a mapping

Answer

To sort records into a numerically ascending sequential order

Answer

To create alphabetically sequenced output file names for batch exports

Answer

To detect and flag out-of-sequence records in the data stream

Question 7

In Informatica Cloud, what is a Rank transformation primarily used for?

Accepted Answer

To select a specified number of top or bottom records based on a ranking field

Answer

To sort all records in the dataset in a specified order

Answer

To deduplicate records and keep only the highest-ranked version

Answer

To route records to different output groups based on their rank score