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

How many areas for files does datastage have?

0 Answers  


Lookup constraints

0 Answers   CTS,


Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,


HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,


What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 Answers  






hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 Answers  


What is orabulk stage?

0 Answers  


i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers  


1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers   EDS,


What are the types of containers?

0 Answers  


WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,


i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

7 Answers   TCS,


Categories