What is Active and Passive transformation in Informatica?

0 votes

An Active transformation can change teh number of rows that pass through it from source to traget. It eliminates rows that do not meet the condition in transformation.

A Passive transformation does not change teh number of rows that pass through it i.e., it passes all rows through the transformation.

List of transformations coming under **Active transformations** are -

```
Source Qualifier Transformation
Aggregator Transformation
Filter Transformation
Rank Transformation
Joiner Transformation
Router Transformation
Normalizer Transformation
Update strategy Transformation
Sorter Transformation
ERP Source Qualifier Transformation
Advanced External Procedure Transformation
```

And here find the **Passive Transformations list** -

```
Expression Transformation
Sequence Generatoe Transformation
LookUP Transformation
Stored Procedure Transformation
XML Source Qualifier Transformation
External procedure Transformation
Input Transformation(Mapplet)
Output Transformation(Mapplet)
```

...