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 normalization and denormalization
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Enlist various types of routines in datastage.
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is RCP
how to change left and right links in join stage?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
can we use sequential file as a lookup
What is apt_config in datastage?
How you can fix the truncated data error in datastage?