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 is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
How do you generate sequence number in datastage?
How to clean the datastage repository?
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Why we need datasets ratherthan sequential files?
What is difference between symmetric multiprocessing and massive parallel processing?
How many nodes supported by a one cpu in parallel jobs?
how to call sequential generator in datastage?
What are the job parameters?