Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43683 Views
- MCA, Symphony, TCS, I also Faced
- E-Mail Answers
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 sequential file and data set?
What is a folder? Difference types of stages?
How you can fix the truncated data error in datastage?
How a server job can be converted to a parallel job?
why do u need the IOS upgradation in a FC switch
Define repository tables in datastage?
What is quality stage?
What is the process of killing a job in datastage?
How do you import and export data into datastage?
How do you import and export the datastage jobs?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are the steps required to kill the job in Datastage?
How rejected rows are managed in datastage?
Can you explain repository tables in datastage?
What is the difference between account and directory options ?
