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