Alphabetical list of stages in DataStage

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
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.

Alphabetic A – F: Stages in parallel jobs or server jobs


Stage name Job type Palette category Delivery and notes
Address Verification Parallel Data Quality2
Aggregator Parallel, server Processing
BASIC Transformer3 Parallel Processing Superseded by the Transformer stage
CASS Parallel Data Quality2
CDC Transaction Parallel Real Time Delivered as the CDC Transaction patch
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 Stage  Server Processing
Compare Parallel Processing
Complex Flat File Parallel, server File
Compress Parallel Processing
Copy Parallel Processing
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
Direct Access for PeopleSoft Enterprise Parallel, server Application
Distributed Transaction Parallel Database
DPID Parallel Data Quality2
DRS Connector Parallel, server Database
Dynamic RDBMS Parallel, server Database Superseded by the DRS Connector stage (Dynamic Relational Stage Connector stage)
Encode Parallel Processing
Essbase Connector Parallel Application
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

Alphabetic G – P: Stages in parallel jobs or server jobs


Stage name Job type Palette category Delivery and notes
Generic Parallel Processing
Hashed File Server File
Head Parallel Development/Debug
Hierarchy for PeopleSoft Enterprise Parallel, server Application
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
Java Transformer Parallel, server Real Time
JD Edwards EnterpriseOne Parallel, server Application
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
Merge  Parallel, server Processing
MNS (Multinational Standardization) Parallel Data Quality1
Modify Parallel Processing
MS OLEDB Server Database
MS SQL Server Load Server Database
Netezza Enterprise Parallel Database Documentation is available only with the installed product
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
Oracle Applications Direct Access Parallel, server Application
Oracle Applications Hierarchy Access Parallel, server Application
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

Alphabetic Q – Z : Stages in parallel jobs or server jobs

Stage name Job type Palette category Delivery and notes
QualityStage Legacy Parallel Data Quality1
RedBrick Load Parallel, server Database
Reference Match Parallel Data Quality1
Remove Duplicates Parallel Processing
Row Generator Parallel Development/Debug
Row Merger Server Processing
Row Splitter Server Processing
Salesforce Parallel Application
Sample Parallel Development/Debug
(SAP BW) BW Load Parallel, server Application
(SAP BW) BW Open Hub Parallel, server Application
(SAP R/3) ABAP Extract Parallel, server Application
(SAP R/3) BAPI Parallel, server Application
(SAP R/3) IDoc Extract Parallel, server Application
(SAP R/3) IDoc Load Parallel, server Application
SAS Parallel Application
SAS Parallel Data Set Parallel Application
Sequential File Parallel, server File
SERP (Software Evaluation and Recognition Program) Parallel Data Quality2
Siebel BC Pack (Business Component) Parallel, server Application
Siebel DS Pack (Direct Access) Parallel, server Application
Siebel EIM Pack (Enterprise Integration Manager) Parallel, server Application
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
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
Unduplicate Match Parallel Data Quality1
UniData® Server Database
UniData 6 Server Database Superseded by the UniData stage
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 Parallel, server Real Time Delivered as the XML Transformer patch
XML Input Parallel, server Real Time Superseded by the XML stage
XML Output Parallel, server Real Time Superseded by the XML stage
XML Transformer Parallel, server Real Time Superseded by the XML stage
zOS File Parallel File


Stages that are available in sequence jobs

 

Stage name Palette category
EndLoop Activity Sequence
Exception Handler Sequence
Execute Command Sequence
Job Activity Sequence
Nested Condition Sequence
Notification Activity Sequence
Routine Activity Sequence
Sequencer Sequence
StartLoop Activity Sequence
Terminator Activity Sequence
UserVariables Activity Sequence
Wait For File Activity Sequence

Leave a Reply

Your email address will not be published. Required fields are marked *