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

In Informatica PowerCenter, a mapping is the fundamental object that defines the flow of data from source to target. It graphically represents the data transformation logic, illustrating how data is extracted, manipulated, and loaded using various transformations. Mappings serve as the core blueprints for data integration processes, specifying the exact steps for data movement and modification.

Question 2

Which transformation is used to filter rows in a mapping?

Accepted Answer

Filter transformation

Answer

The Filter transformation in Informatica PowerCenter is specifically designed to filter rows of data based on a user-defined condition. Only those rows that satisfy the specified condition are passed through to the next transformation or target. This allows for selective processing of data, ensuring that only relevant records continue in the data flow.

Question 3

What is the purpose of an Expression transformation?

Accepted Answer

To perform calculations or data manipulation

Answer

The Expression transformation in Informatica PowerCenter is a versatile tool used to perform calculations, concatenate strings, convert data types, or apply any other row-level data manipulation. It allows users to define expressions using various functions and operators to derive new values, modify existing ones, or implement complex business logic within the data flow.

Question 4

Which transformation allows branching based on multiple conditions?

Accepted Answer

Router transformation

Answer

The Router transformation in Informatica PowerCenter is used to branch data rows into multiple output groups based on different, user-defined conditions. Unlike a simple Filter, which only passes or drops rows, the Router can direct rows to various distinct pipelines simultaneously. This enables complex conditional data flow and processing based on multiple criteria.

Question 5

What transformation is used to combine data from two sources?

Accepted Answer

Joiner transformation

Answer

The Joiner transformation in Informatica PowerCenter is used to combine data from two heterogeneous sources or pipelines into a single stream. It performs a join operation, similar to a SQL JOIN, based on a specified join condition between the input data sets. This allows for integrating related data from different origins into a unified data flow.

IPC - Informatica PowerCenter Certification Practice Test

IPC - Informatica PowerCenter Certification Practice Test

FREE IPC Mapping Design & Transformation Techniques Questions and Answers