FREE IPC Mapping Design & Transformation Techniques Questions and Answers

Question 1

What is a mapping in Informatica PowerCenter?

Accepted Answer

A design of data flow and transformations

Answer

A set of workflow tasks.

Answer

A session log.

Answer

An execution schedule.

Question 2

Which transformation is used to filter rows in a mapping?

Accepted Answer

Filter transformation

Answer

Router transformation.

Answer

Aggregator transformation.

Answer

Expression transformation.

Question 3

What is the purpose of an Expression transformation?

Accepted Answer

To perform calculations or data manipulation

Answer

To route data based on conditions.

Answer

To join data from multiple sources.

Answer

To remove duplicate rows.

Question 4

Which transformation allows branching based on multiple conditions?

Accepted Answer

Router transformation

Answer

Joiner transformation.

Answer

Filter transformation.

Answer

Sorter transformation.

Question 5

What transformation is used to combine data from two sources?

Accepted Answer

Joiner transformation

Answer

Aggregator transformation.

Answer

Lookup transformation.

Answer

Sorter transformation.

Question 6

How does an Aggregator transformation function?

Accepted Answer

Performs aggregate functions on grouped data

Answer

Filters rows based on condition.

Answer

Splits data into multiple streams.

Answer

Joins two data sets.

Question 7

Which transformation is used to find and replace values in a data stream?

Accepted Answer

Normalizer transformation

Answer

Router transformation.

Answer

Filter transformation.

Answer

Joiner transformation.

Question 8

What is the use of a Lookup transformation?

Accepted Answer

To fetch data from a relational table or file

Answer

To join two pipelines.

Answer

To filter rows.

Answer

To aggregate data.

Question 9

Which transformation is used to sort data before loading into target?

Accepted Answer

Sorter transformation

Answer

Aggregator transformation.

Answer

Expression transformation.

Answer

Router transformation.