ICC Mappings & Transformations

Question 1

In Informatica Cloud Data Integration, what is the primary purpose of a mapping?

Accepted Answer

To define the flow of data from sources to targets, including all transformations applied along the way

Answer

To schedule data integration tasks at specific times

Answer

To define connection properties for source and target systems

Answer

To monitor the performance of data integration jobs

Question 2

Which transformation in Informatica Cloud is specifically used to pass only rows that meet a specified condition?

Accepted Answer

Filter

Answer

Router

Answer

Expression

Answer

Sorter

Question 3

What is the primary function of a Joiner transformation in Informatica Cloud?

Accepted Answer

To join data from two heterogeneous sources based on a join condition

Answer

To split data into multiple output pipelines

Answer

To aggregate data based on grouping criteria

Answer

To generate unique sequence numbers for records

Question 4

Which Informatica Cloud transformation can generate multiple output rows from a single input row containing repeating data?

Accepted Answer

Normalizer

Answer

Aggregator

Answer

Router

Answer

Rank

Question 5

What does the Expression transformation in Informatica Cloud primarily allow you to do?

Accepted Answer

Calculate values and perform row-level transformations without changing the number of rows

Answer

Filter records based on conditions without passing rows forward

Answer

Join two data streams together using a key field

Answer

Route data to different targets based on conditional logic

Question 6

In Informatica Cloud, what is the purpose of a Lookup transformation?

Accepted Answer

To search a lookup source and return matching values based on a specified lookup condition

Answer

To rank records based on a specified column value

Answer

To split incoming data into multiple conditional output groups

Answer

To sort data in ascending or descending order before target load

Question 7

How can the Sorter transformation in Informatica Cloud be used to remove duplicate rows from a data flow?

Accepted Answer

By enabling the Distinct property on the Sorter transformation

Answer

By enabling the Remove Duplicates option in the transformation properties

Answer

By configuring the Distinct sort key in the output port settings

Answer

By setting the Deduplication flag in the advanced transformation settings