Question: What is UNION Transformation in Informatica Powercenter?

Union Transformation is an active transformation. It merges data which is coming from multiple sources either from homogenous or from heterogeneous. It merges data in vertical roe by row format.

It gives duplicate row if duplicate data is available in source table.

It is equivalent to UNION ALL set operator of SQL.

Input may have multiple groups but has only one output group.

Input and output group must have matching port to UNINON Data.

It does not generate transactions.

Question: What is RANK Transformation?

It is active and connected Transformation.

It is used to filtering the records based on Group and Ranks

Rank Transformation in Informatica is equivalent to RANK function of SQL.

Rank Transformation is mostly used to rank numeric port values in the form of Min and Max value to provide ranking to the records.

Rank Transformation has four types of port.

Input Port(I): This Port is used to receive data from the other transformation in mapping.

Output Port(O): This port is used to transform data to other port as output.

Variable Port(V): It is used to store values or calculations that is to be used in an expression.

Rank Port(R). It is used to calculate rank based on the group on which the user want rank.

Question: What is FILTER Transformation?

It filters the data from the sources based on the specified condition. it is used to remove unwanted data from the mapping.

Filter Transformation is an active and connected transformation.

Filter Transformation condition is an expression that returns TRUE or FALSE value. When the filter condition returns TRUE for a row, the Filter transformation passes all the records and this time it behaves as Passive Transformation. When the filter condition returns FALSE, the Filter transformation drops all the records of the source and not passes any data to other Transformation.

On True conditions the filter transformation behaves as Passive Transformation and with other condition it behaves as Active Transformation.

Question: What are the PowerCenter Repository in Informatica Powercenter?

Following are the PowerCenter Repository in Informatica

Source Definition

Mapping

Target Definition

Session and session logs

ODBC Connection

Workflow

Question: How to generate sequence numbers/ incremental numbers using expression transformation in Informatica Powercenter while doing mapping?

Method 1.

In the expression transformation, create a variable port(V_count) and increment it by 1. Then assign the variable port to an output port(O_count).

In the expression transformation, the ports are:

V_count = V_count+1

O_count = V_count

Method 2.

Choose sequence generator transformation and connect NEXTVAL port of sequence generator to expression. This port will provide the incremental value to expression as input.

Also choose start value =1 and incremented by 1 to get numeric series of 1,2,3….

Click here, for more Informatica Powercenter interview Question and Answer