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
What are the functionalities of link partitioner and link collector?
Define project in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the enhancements made in datastage 7.5 compare with 7.0?
What are sequencers?
What is the difference between odbc and drs stage?
Which algorithm you used for your hashfile?
What is active and passive stage?
Describe routines in datastage? Enlist various types of routines.
How a source file is populated?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the difference between server job and parallel jobs?
What can we do with datastage director?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Describe the main features of datastage?