What is a Transformation?

  • A Transformation is a repository object that generates, modifies or passes data.
  • It is the logic to Informatica to transform the data according to the business needs.

Types of Transformations

Transformations are basically of two types:

  • Active
  • Passive

Active Transformation

A transformation is called as an active transformation if it allows change in the record count.

e.g. If there are 20 records coming from the source but only 5 are sent to the target after transformation.

ActiveTransformation

Passive Transformation

A transformation is called as a passive transformation if it does not allow any change in the record count.

e.g. If there are 20 records coming from the source and all 20 are sent to the target after transformation.

PassiveTransformation

What are Ports?

  • Column names are called Ports.
  • Every transformation identifies incoming data with input ports.
  • Every transformation works on input ports, output ports and some internal ports.
  • Based on the ports and properties the functionality of the transformation will change.

 

What are the different ways to use a Transformation?

A transformation can be used in two ways:

Connected Transformation

In a pipeline .The transformation used in a mapping are said to be in a pipeline.

Unconnected Transformation

Outside the pipeline.

Commonly used Transformations

No. Transformation Logic Type
1 Source Qualifier Active
2 Filter Active
3 Sorter Active
4 Expression Passive
5 Aggregator Active
6 RANK Active
7 ROUTER Active
8 Sequence Generator Passive
9 Joiner Active
10 Union Active
11 Look-up(connected/unconnected) Passive
12 Stored Procedure (connected/unconnected) Passive
13 Update Strategy Active
14 Transaction Control Active
15 XML Source Qualifier Active
16 Normalizer Active
17 Application Source Qualifier (SAP Application Sources) Active
18 Application Multigroup Source Qualifier (SAP Application Sources) Active
19 MQ-Series (Message Queuing System) Active
20 Midstream XML Generator (TIBCO) Active
21 Midstream XML Parser (TIBCO) Active