Active vs Passive stages

Reading Time: < 1 minute

In datastage we have two types of stages

Active stages:  Stages that are used for data processing (define how data is filtered and transformed) are referred as active stages.

      Ex- Join, Lookup, Transformer, Filter, Aggregator, Sort (plug-in)

Passive stages:  Stages that are used to read the data from database and write data to the database is called passive stages.

     Ex- OracleEnterprise, Teradata, Dataset, Sequential, ODBC, UniVerse, Hashed