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

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

Question Posted / bharath

1 Answers
4302 Views
IBM, I also Faced
E-Mail Answers

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

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers

how to call routines in stages?

3 Answers ME,

Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers Systime,

why we use hash file for lookup?

5 Answers

I have 100 records how can I load at a time from the single time

1 Answers

How do you run datastage job from the command line?

0 Answers

Hi Vijay here For Four CPU's how many nodes will required?