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
Terminate Activity
Lookup constraints
what is the use of materialized view?
What is orabulk stage?
explain about citrix scheduling tool in datastage
Define data aggregation?
What is a datastage job?
Define meta stage?
What are the types of containers and how to create them?
Difference between in process and inter process?
Why we use surrogate key?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is the method of removing duplicates, without the remove duplicate stage?
Name the command line functions to import and export the DS jobs?
Can you explain players in datastage?