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

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?

Accepted Answer

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

Answer

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:

Accepted Answer

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

Answer

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?

Accepted Answer

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

Answer

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?

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 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.

(ICC) Informatica Cloud Certification Practice Test

(ICC) Informatica Cloud Certification Practice Test

ICC Mappings & Transformations 2