Transformation and Types of Transformation in Informatica

A transformation is a power center object which allows you to write transformation logic (or) business logic use to for processing the data.

There are two type of transformations.

  • Active transformation
  • Passive transformation

Informatica Active Transformation

A transformation which can affect the no. Of rows (or) change the no of rows when the data is moving from source to target is known as active transformation.

The following are the list of active transformations used for processing the data.

Source Qualifier Transformation

Filter transformation

Ruler transformation

Rank Transformation

Sorter Transformation

Joiner transformation

Union Transformation

Aggregate Transformation

Transaction control transformation

Normalize transformation

Lookup Transformation

Update strategy transformation

SQL Transformation

Router Transformation

Expression Transformation

Informatica Passive Transformation

A Transformation  which doesn’t change the no of rows when the data is moving from source to target is known as passive transformation in Informatica.

The no of rows entering the transformation is same as no of rows exist the transformation.

It doesn’t effect  the no of rows.

The following are the list of passive transformations used for processing data.

  • Expression transformation
  • Sequence generated transformation
  • Stored procedure transformation
  • Look up transformation
  • XML source qualifier transformation
  • SQL Transformation

Connected and Unconnected Transformations in Informatica

Connected Transformation

A transformation which is part of mapping data flow direction is known as connected transformation. It is connected the source and connected to the target.

All active and passive transformation can be refined as connected transformation.

A connected transformation can receive multiple input ports, can provide the multiple output ports.

Unconnected transformations

A transformation which is not part of mapping data flow direction is known as un-connected transformations. It is neither connected to source nor connected to the target.

An unconnected transformation can receive the multiple input ports, but provides “single output port”.

The following transformations can be defined as unconnected.

  • Stored procedure transformation
  • Lookup transformation

These core tutorials will help you to learn the fundamentals of Informatica. For an in-depth understanding and practical experience,  explore Informatica Training Online.

Data flow Diagram Active, Passive Transformations

Transformation Types in Informatica

Portland types of ports

A port represents column of a table (or)file. There are two basic type of ports.

  • Input port:-

A port which can receive the data is known as input port which is represented as:”I”

  • Output Port:-

A port which can provide the data is known as output port which is represented as “o”.

Transformation Types in Informatica

For in-depth understanding of Informatica click on