Transformations can be active or passive. An active transformation can change the number of rows that pass through it, such as a Filter transformation that removes rows that do not meet the filter condition. A passive transformation does not change the number of rows that pass through it, such as an Expression transformation that performs a calculation on data and passes all rows through the transformation

Active transformations

Advanced External Procedure

Aggregator

Application Source Qualifier

Filter

Joiner

Normalizer

Rank

Router

Update Strategy

Passive transformation

Expression

External Procedure

Maplet- Input

Lookup

Sequence generator

XML Source Qualifier

Maplet - Output

Cheers,

Sithu