Interested to Buy Any Domain ? << Click Here >> for more details...
Parallel job contains more than 20 stages.
I want to find out which stage is more performance
incentive.
- 1 Answers
- 4376 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the different types of lookups in datastage?
in oracle target stage when we use load option and when we use upsert option?
What are iconv and oconv?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
how many rows sorted in sort stage by default in server jobs
State the difference between an operational datastage and a data warehouse?
Name the command line functions to import and export the DS jobs?
Name the different types of Lookups in Datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Describe the architecture of datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
how to delete one row in target dataset
What a datastage macro?
What is active and passive stage?
