May 10, 2014 \ Ananth TM 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