Datastage Tutorials

Aggregator Stage In Parallel Jobs

Which Partition We Have To Use For Aggregator Stage In Parallel Jobs?

Aggregator Stage is a processing stage in DataStage is used to grouping and summary operations. By Default Aggregator stage will execute in parallel mode...
Link Partitioner and Link Collector

What is the need of Link Partitioner and Link Collector in DataStage?

In this article, today we are going to discuss the need of link partitioner and link collector in DataStage. Already, we have discussed more...

Cumulative Sum Calculation Solve with steps in Datastage

-------------------------- 10, 1000 20, 2000 30, 3000 40, 5000Display as employee_id, salary, cumulative_sum ----------------------------------- 10, 1000, 1000 20, 2000, 3000 30, 3000, 6000 40, 5000, 11000 * You can have single stage variable svSum with...

An overview of DataStage components

For Business Intelligence (BI) market is very much dependent on ETL architecture. The Extract, Transform and Loading products have become far more important in...

Message Handler

When you run a Parallel Job , any error messages and warnings are written to an error log and can be viewed from the...

What is Permissions Page

This section describes Datastage user categories and how to change the assignment of these categories to operating system user groups. Datastage User Categories : To...