Parallel job contains more than 20 stages.
I want to find out which stage is more performance
incentive.

Answer Posted / nish

read the dump score and player timings to find out whioch stages/nodes are taking more CPU time for execution.

consider splitting your job into parts optimally and compare the performance with the original design.

try to reduce number of transformer stages.
Check for unnecessary re-partitioning being introduced.

Hope it helps!

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3005


What is quality stage?

579


How to reverse the string using SQL?

907


what are the devoleper roles in real time? plz tell i am new to datastage....

1653


What are the components of ascential data stage?

662






what is the use of skid in reporting?

1961


Differentiate between data file and descriptor file?

629


Where do you see different stages in the designer?

648


What is active and passive stage?

897


What a datastage macro?

649


Can you define merge?

674


Have you used Unstructured data?

841


Where the datastage stored his repository?

632


Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2852


Why do we use exception activity in Datastage?

737