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.
The stages in this document are included and available with
IBM InfoSphere DataStage unless
otherwise noted in the following key.
| 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 |
The following key includes additional notes about stages
in the Designer client.
| 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.
Table 1. Alphabetic A - F: Stages in parallel jobs or server jobs| 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 |
| DB2 UDB
API3 |
Parallel, server |
Database |
Superseded by the DB2 Connector
stage |
| DB2 UDB
Load3 |
Parallel, server |
Database |
Superseded by the DB2 Connector
stage |
| DB2Z 3 |
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 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 |
|
Table 2. Alphabetic
G - P: Stages in parallel jobs or server jobs| 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 7 Load |
Server |
Database |
Superseded by the Oracle Connector stage |
| Oracle Connector |
Parallel, server |
Database |
|
| Oracle Enterprise3 |
Parallel |
Database |
Superseded by the Oracle Connector stage |
| Oracle OCI (Oracle Call Interface)3 |
Server |
Database |
Superseded by the Oracle Connector stage |
| Oracle OCI Load3 |
Parallel, server |
Database, Application |
Superseded by the Oracle Connector stage |
| 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 |
|
Table 3. Alphabetic
Q - Z: Stages in parallel jobs or server jobs| 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 |
Superseded by the Teradata Connector stage |
| Teradata Connector |
Parallel, server |
Database |
|
| Teradata Enterprise 3 |
Parallel |
Database |
Superseded by the Teradata Connector stage |
| Teradata Load3 |
Parallel, server |
Database |
Superseded by the Teradata Connector stage |
| Teradata Multiload3 |
Parallel, server |
Database |
Superseded by the Teradata Connector stage |
| 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.
IBM InfoSphere DataStage, Version 11.3.1
Last updated: 2014-06-30