Commonly used stages
Aggregator
Complex flat file
Column Import
Column Export
Dataset
Distributed transaction (new in 8.1)
FTP Enterprise
Join
Lookup
Merge
Funnel
Sequential file
Sort
Slowly changing dimension
Transformer
Surrogate key Generator
Stages
General
Annotation
Container
Link
Discription Annotation
Database
DB2/UDB enterprise
Oracle enterprise
Teradata enterprise
Teradata multiload
Informix enterprise
ODBC enterprise
Dynamic RDBMS
Sybase enterprise
Stored Procedure
Development
Debug
Head
Tail
Sample
Peek
Row/Column
Generator
Write range map
File
Sequential file
Dataset
Fileset
Lookup fileset
Complex flat file (CFF)
External source
External target
SAS Dataset
Processing
Transformer
Basic transformer
Aggregator
Join
Merge
Lookup
Sort
Funnel
Remove duplicates
Compress
Expand
Copy
Filter
External filter
Change Capture
Change apply
Difference
Compare
Encode
Decode
Switch
FTP
SAS
Generic
Surrogate key
Realtime
RTI Input
RTI Output
XML Input
XML Output
XML
Transformer
Web services trnasformer
Websphere MQ
Webservices client
Restructure
Column import
Column Export
Make subrecord
Split subrecord
Combine record
Promote subrecord
Make Vector
Split Vector
Parallel Processing
Pipeline Parallelism
Partition Parallelism
Keyless Partitioner
Round Robin Partitioner
Random Partitioner
Same Partitioner
Entire Partitioner
Key based Partitioner
Hash Partitioner
Modulus partitioner
Range Partitioner
DB2 EEE partitioner
Auto Partitioner
Typically it uses Round robin partitioner
Collector
Round Robin Collector
Ordered Collector
Sorted Merge Collector
Auto Collector