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
How many Key we can define in remove duplicate stage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
how to sort two columns in single job in datastage.
How can we improve the performance in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the primary usages of datastage tool?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
what is repositery?
Is possible to create skid in dim,fact tables?
What is the importance of the exception activity in datastage?
What are some different alternative commands associated with "dsjob"?
How to implement complex jobs in data stage?
how to write server Routine coding?
What is orabulk stage?
What is the differentiate between data file and descriptor file?