A Transformation is a power center object which allows you to develop the business rules to process the Data through ports that we connect to mapping or mapplet.

Two types of Transformations

        Active Transformation.

 Passive Transformation

Active Transformation:

                     A Transformation which can change the No of rows or affect the no rows when the data is moving from source to target [destination] is Called Active Transformation.

Ø  Filter Transformation.

Ø  Router Transformation.

Ø  Source qualifier Transformation

Ø  Aggregator Transformation.

Ø  Sorter Transformation.

Ø  Joiner  Transformation

Ø  Rank Transformation.

Ø  Union Transformation.

Ø  Update strategy Transformation

Ø  Normalizer Transformation.

Ø  Transaction control Transformation.

Ø  SQL Transformation

 Passive Transformation:

                    A transformation does not change the number of rows .when data is moving from source to   destination is called Passive Transformation.

Ø  Expression Transformation.

Ø  Sequence generator Transformation.

Ø  Lookup Transformation.

Ø  Stored Procedure Transformation.

Ø  SQL Transformation.

Ø  XMK Source qualifier Transformation

All Active Transformations are used to filtering and cleansing the data.