Alphabetical list of stages
The following tables contain an alphabetized list of all the stages that are available in IBM® InfoSphere® Information Server, Version 11.3, as included with the base installation or with add-on installations.
Whether a particular stage is displayed on the IBM InfoSphere DataStage® Designer client palette depends on the type of job you are creating and the products and add-ons that you installed. For a list of available add-ons, see www.ibm.com/support/docview.wss?uid=swg21671828. On the palette, stages are organized by category. In this document, stages are organized alphabetically.
- Parallel job stages and server job stages (alphabetically, by name)
The stages in this document are included and available with IBM InfoSphere DataStage unless
otherwise noted in the following key.
The following key includes additional notes about stages
in the Designer client.
Palette category | Description |
---|---|
Data Quality1 | Available only with IBM InfoSphere QualityStage® |
Data Quality2 | Available as a separately licensed add-on module to InfoSphere QualityStage |
Data Quality3 | Available only with InfoSphere Information Analyzer |
Application | Available as an add-on Pack to IBM InfoSphere DataStage and QualityStage |
Stage name | Description |
---|---|
Stage name3 | Available in the Stage Types folder in the repository tree, but is not displayed in the palette by default. |
Parallel job stages and server job stages
The following stages are available
when you create a parallel job or server job. The Delivery and
notes column describes additional usage and availability information
for some stages.
Stage name | Job type | Palette category | Delivery and notes |
---|---|---|---|
ABAP Extract | Parallel, server | Application | |
Aggregator | Parallel, server | Processing | |
Amazon S3 Connector | Parallel | File | |
BAPI | Parallel, server | Application | |
BASIC Transformer3 | Parallel | Processing | Superseded by the Transformer stage |
Big Data File | Parallel | File | |
CDC Transaction | Parallel | Real Time | |
Change Apply | Parallel | Processing | |
Change Capture | Parallel | Processing | |
Checksum | Parallel | Processing | |
Classic Federation | Parallel | Database | |
Column Export | Parallel | Restructure | |
Column Generator | Parallel | Development/Debug | |
Column Import | Parallel | Restructure | |
Combine Records | Parallel | Restructure | |
Command | Server | Processing | |
Compare | Parallel | Processing | |
Complex Flat File | Parallel, server | File | |
Compress | Parallel | Processing | |
Copy | Parallel | Processing | |
Data Rules | Parallel | Data Quality3 | |
Data Set | Parallel | File | |
DB2® Connector | Parallel, server | Database | |
DB2 Enterprise | Parallel | Database | Superseded by the DB2 Connector stage |
Decode | Parallel | Processing | |
Difference | Parallel | Processing | |
Distributed Transaction | Parallel | Database | |
DRS Connector | Parallel, server | Database | |
Dynamic RDBMS | Parallel, server | Database | Superseded by the DRS Connector stage (Dynamic Relational Stage Connector stage) |
Encode | Parallel | Processing | |
Expand | Parallel | Processing | |
External Filter | Parallel | Processing | |
External Source | Parallel | File | |
External Target | Parallel | File | |
File Connector | Parallel | File | |
File Set | Parallel | File | |
Filter | Parallel | Processing | |
Folder | Server | File | |
FTP Enterprise | Parallel | Processing | |
FTP Plug-in | Parallel, server | Processing | Superseded by the FTP Enterprise stage on the parallel canvas |
Funnel | Parallel | Processing |
Stage name | Job type | Palette category | Delivery and notes |
---|---|---|---|
Generic | Parallel | Processing | |
Greenplum Connector | Parallel | Database | |
Hashed File | Server | File | |
Head | Parallel | Development/Debug | |
Hierarchical Data | Parallel | Real Time | |
IDoc Extract Connector | Parallel, server | Application | |
IDoc Load Connector | Parallel, server | Application | |
iLog JRules Connector | Parallel | Processing | |
Informix® CLI | Parallel, server | Database | |
Informix Enterprise | Parallel | Database | |
Informix Load | Parallel, server | Database | |
Informix XPS Load3 | Server | Database | |
InterProcess | Server | Processing | |
Investigate | Parallel | Data Quality1 | |
ISD Input | Parallel, server | Real Time | |
ISD Output | Parallel, server | Real Time | |
iWay Enterprise | Parallel | Database | |
Java™ Client | Parallel, server | Real Time | Superseded by the Java Integration stage |
Java Integration | Parallel | Real Time | |
Java Transformer | Parallel, server | Real Time | Superseded by the Java Integration stage |
JDBC Connector | Parallel | Database | |
Join | Parallel | Processing | |
Link Collector | Server | Processing | |
Link Partitioner | Server | Processing | |
Lookup | Parallel | Processing | |
Lookup File Set | Parallel | File | |
Make Subrecord | Parallel | Restructure | |
Make Vector | Parallel | Restructure | |
MapStage (for TX) | Parallel | Application | Delivered as IBM WebSphere Transformation Extender for DataStage |
Match Frequency | Parallel | Data Quality1 | |
Master Data Management Connector | Parallel | Application | |
Merge | Parallel, server | Processing | |
MNS (Multinational Standardization) | Parallel | Data Quality1 | |
Modify | Parallel | Processing | |
MS OLEDB | Server | Database | |
MS SQL Server Load | Server | Database | |
Netezza Connector | Parallel | Database | |
Netezza Enterprise | Parallel | Database | Superseded by the Netezza Connector stage |
ODBC | Server | Database | Superseded by the ODBC Connector stage |
ODBC Connector | Parallel, server | Database | |
ODBC Enterprise3 | Parallel | Database, Application | Superseded by the ODBC Connector stage |
One-source Match | Parallel | Data Quality1 | |
Oracle Connector | Parallel, server | Database | |
Peek | Parallel | Development/Debug | |
Pivot | Parallel, server | Processing | Superseded by the Pivot Enterprise stage on the parallel canvas |
Pivot Enterprise | Parallel | Processing | |
Promote Subrecord | Parallel | Restructure |
Stage name | Job type | Palette category | Delivery and notes |
---|---|---|---|
RedBrick Load | Parallel, server | Database | |
Remove Duplicates | Parallel | Processing | |
Row Generator | Parallel | Development/Debug | |
Row Merger | Server | Processing | |
Row Splitter | Server | Processing | |
Sample | Parallel | Development/Debug | |
SAS | Parallel | Application | Documentation is available only with the installed product |
SAS Parallel Data Set | Parallel | Application | Documentation is available only with the installed product |
Sequential File | Parallel, server | File | |
Slowly Changing Dimension | Parallel | Processing | |
Sort | Parallel, server | Processing | |
Split Subrecord | Parallel | Restructure | |
Split Vector | Parallel | Restructure | |
SQA (Standardization Quality Assessment) | Parallel | Data Quality1 | |
SQLServer Enterprise | Parallel | Database | |
Standardize | Parallel | Data Quality1 | |
Stored Procedure | Parallel, server | Database | |
Streams Connector | Parallel | Real Time | |
Surrogate Key Generator | Parallel | Processing | |
Survive | Parallel | Data Quality1 | |
Switch | Parallel | Processing | |
Sybase BCP Load | Server | Database | |
Sybase Enterprise | Parallel | Database | |
Sybase IQ 12 Load | Parallel, server | Database | |
Sybase OC | Parallel, server | Database, Application | |
Tail | Parallel | Development/Debug | |
Teradata API3 | Parallel, server | Database | |
Teradata Connector | Parallel, server | Database | |
Teradata Enterprise 3 | Parallel | Database | |
Teradata Load3 | Parallel, server | Database | |
Teradata Multiload3 | Parallel, server | Database | |
Teradata API3 | Parallel, server | Database | |
Transformer | Parallel, server | Processing | |
Two-source Match | Parallel | Data Quality1 | |
UniData | Server | Database | |
Unstructured Data | Parallel | File | |
UniVerse | Server | Database | |
Wave Generator | Parallel | Processing | |
Web Services Client | Parallel, server | Real Time | |
Web Services Transformer | Parallel, server | Real Time | |
WebSphere® MQ3 | Parallel, server | Real Time | Superseded by the WebSphere MQ Connector stage |
WebSphere MQ Connector | Parallel, server | Real Time | |
Write Range Map | Parallel | Development/Debug | |
XML Input | Parallel, server | Real Time | Superseded by the Hierarchical Data stage |
XML Output | Parallel, server | Real Time | Superseded by the Hierarchical Data stage |
XML Transformer | Parallel, server | Real Time | Superseded by the Hierarchical Data stage |
zOS File | Parallel | File |
Sequence job stages
The following stages are available when you create a sequence job.
Stage name | Palette category |
---|---|
EndLoop Activity | Sequence |
Exception Handler | Sequence |
Execute Command | Sequence |
Job Activity | Sequence |
Nested Condition | Sequence |
Notification Activity | Sequence |
Oozie Workflow Activity | Sequence |
Routine Activity | Sequence |
Sequencer | Sequence |
StartLoop Activity | Sequence |
Terminator Activity | Sequence |
UserVariables Activity | Sequence |
Wait For File Activity | Sequence |