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



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

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

Post New Answer

More Data Stage Interview Questions

source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235

6 Answers   US Technology,


how can u handle null values in transformer stage.

7 Answers  


what is the main difference between sorragate key n primary key in one word

2 Answers  


LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

2 Answers   Mannar Company, ME,


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,






how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,


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 ?

4 Answers   HCL,


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  


How do you find the number of rows in a sequential file?

1 Answers  


diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,


hi i am madan, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer 

1 Answers   HCL,


Terminate Activity

0 Answers   CTS,


Categories