Below is in detail Difference between Active and Passive Transformations. In Informatica, transformations are categorized as either active or passive. transformations are used to apply the logic.
| Active Transformation | Passive Transformation |
| Definition: An active transformation Row count has been changed | Definition: A passive transformation Row count has not been changed |
| Can filter rows (e.g., Filter Transformation). | Maintains the row count from source to target. |
| Can change the row type (e.g., Update Strategy Transformation). Can generate new rows (e.g., Aggregator Transformation with `GROUP BY` clause). | Typically used for lookups, expressions, and data type conversions. |
| Filter Transformation: Filters out rows that do not meet specified conditions. Joiner Transformation: Joins data from two heterogeneous sources. Aggregator Transformation: Performs aggregate calculations, potentially reducing the number of rows. | Expression Transformation: Performs calculations on a row-by-row basis. Lookup Transformation: Retrieves related data from a lookup table. Sequence Generator Transformation: Generates unique primary key values. |
List Of Active and Passive Transformations
| Active Transformation | Passive Transformation |
| Source Qualifier Transformation Sorter Transformations Filter Transformation Normalizer Transformation Joiner Transformation Rank Transformation Aggregator Transformations Union Transformation Router Transformation Update Strategy Transformation | Expression Transformation Sequence Generator Transformation Lookup Transformation XML Source Qualifier Transformation Stored Procedure Transformation External Procedure Transformation Input Transformation(Mapplet) Output Transformation(Mapplet) |
Also Read :
1. Detailed Difference between a Taskflow and Linear Taskflow – FAQ
1. What is Check In Check Out in Informatica PowerCenter (Versioning) – in Detailed
Active and Passive Transformations | Active and Passive Transformations