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 |
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
how can u handle null values in transformer stage.
what is the main difference between sorragate key n primary key in one word
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
how to do pergformence tuning in datastage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How do you find the number of rows in a sequential file?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
Terminate Activity