how to do pergformence tuning in datastage?
Answer Posted / veera
HI
1. sorted the data as much as possible in sourc database
2. Remove the unwanted columns from soure DB.
3. Drop the indexes before loading the data and Recreate
after loading the data
4. not use more than 20 stages in a job
5. Reduce the Tx stage
6. Use sort stage before an Aggregator stage (in sort mode)
7. Tuned the Project tunnables in administator for better
performance
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Difference between in process and inter process?
Define Merge?
How do you remove duplicate values in datastage?
Is it possible to query a hash file?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Differentiate between hash file and sequential file?
Difference between server jobs & parallel jobs?
What is the differentiate between data file and descriptor file?
project Steps,hits, Project level HArd things,Solved methods?
What is "fatal error/rdbms code 3996" error?
What is the roundrobin collector?
How to manage date conversion in Datastage?
How one source columns or rows to be loaded in to two different tables?
How we can covert server job to a parallel job?
How the ipc stage work?