DataStage features and usage via web interface

DataStage is an application on a server which acts as an ETL tool that extracts transforms and loads data. DataStage connects to data sources...

Run Time Column Propagation

Runtime column Propogation ( RCP) allows you to define only part of your Table Definition ( Schema) Extra Columns Propogate through the rest...

Automatically handle Job runs that fail

Select this to have Datastage automatically handles failing jobs with in a sequence ( this means that you do not have to have a...

Types of Triggers

Activities Can only have one input trigger , but can have multiple output trigger. Trigger names must be unique for each activity. For example,...

Remove Duplicate Stage Properties – How to Guide

Key: Specifies the colun that defines duplicates. The key can be selected from the drop down key columns .  Duplicate to retain: Specifies which of the duplicate...

Oracle Stage Output Properties

Table: Name of the Oracle Table. Write Method: The available write methods are: Delete ( to delete rows in the target table) Load...

Peek Stage Properties

All Records ( After Skip) : Set to true to print all the records from each partition. By default it is set to face.    Number of records(...

What is Peek Stage in Datastage?

The peek stage is a development/debug stage. It can have a single input link and any number of output links. The peek stage can...

SAS Parallel Data Set Stage

The SAS Parallel Data Set Stage is a file stage. It allows reading data from or writing data to a parallel SAS data set...

Topologies Supported in Datastage

Datastage Parallel Extender is built on a highly scalable parallel software architecture that delivers high levels of through =out and performance. For maximum scalability,...