Transformation and Types of Transformation in Informatica

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

There is two types 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 that 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 the same as no rows exist the transformation.

It doesn’t affect the no of rows.

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

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

Connected and Unconnected Transformations in Informatica

Connected Transformation

A transformation that 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 that 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

If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.

Data flow Diagram Active, Passive Transformations

Transformation Types in Informatica

Portland types of ports

A port represents a 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 that 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