Interested to Buy Any Domain ? << Click Here >> for more details...
how to do pergformence tuning in datastage?
- 4 Answers
- 43403 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 ‘validated ok’ and ‘compiled’ in data stage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Differentiate between datastage and datastage tx?
What are routines in datastage?
What is the difference between the local container and shared container?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the purpose of interprocessor stage in server jobs?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Define Routines and their types?
What is ibm datastage flow designer?
How a routine is called in datastage job?
how many rows sorted in sort stage by default in server jobs
What is the use of datastage designer?
What is the difference between server job and parallel jobs?
Define repository tables in datastage?
