Parallel job contains more than 20 stages.
I want to find out which stage is more performance
incentive.
Answer / 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 |
What are the different types of lookups in datastage?
What is Cleanup Resources and when do you use it?
what is the use of materialized view?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
What is process model?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Define meta stage?
What are the different kinds of views available in a datastage director?
which r the connectors used in san?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
source file contains 100 records, i want 10 records in target file how it possible in datastage
Is there any possibility to generate alphanumeric surrogate key?