1.Active Transformation

Active:

A transformation can be called as an active transformation if it performs any of the following actions.

• Change the number of rows:

         For example, the filter transformation is active because it removes the rows that do not meet the filter condition. All multi-group transformations are active because they might change the number of rows that pass through the transformation.

• Change the transaction boundary: The transaction control transformation is active because it defines a commit or roll back transaction.
• Change the row type: Update strategy is active because it flags the rows for insert, delete, update or reject.