What is active and passive transformation in Informatica?

Question

An active transformation can change the number of rows that pass through the transformation. For example, the Filter transformation is active because it removes rows that do not meet the filter condition. A passive transformation does not change the number of rows that pass through the transformation.

What is difference between active and passive transformation?

An active transformation is a transformation which actually changes the physical position (alibi, elsewhere) of a point, or rigid body, which can be defined in the absence of a coordinate system; whereas a passive transformation is merely a change in the coordinate system in which the object is described (alias, other ...

What are all the passive transformations in Informatica?

The following is the list of passive transformations used for processing data:Expression Transformation in Informatica.Sequence generator transformation in Informatica.Stored procedure transformation in Informatica.Lookup Transformation in Informatica.XML source qualifier transformation in Informatica.

Is router an active or passive transformation?

The Router transformation is an active transformation that you can use to apply a condition to incoming data. passes the row multiple times. You can either drop rows that do not meet any of the conditions or route those rows to a default output group.

Expert · Answer