top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is meant by active and passive transformation?

+1 vote

What is Active and Passive transformation in Informatica?

posted Feb 18, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Active Transformation

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.

Passive 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)
answer Feb 23, 2015 by Manikandan J