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
How we can covert server job to a parallel job?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how many rows sorted in sort stage by default in server jobs
What is a merge?
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?
root tree will find which is server job and which is parallel job?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
AGGREGATOR default datatype
What are the various kinds of the hash file?
What is quality stage?
What are the different layers in the information server architecture?
What is the purpose of pivot stage and types of containers in datastage
If you want to use the same piece of code in different jobs, how will you achieve it?
Is the value of staging variable stored temporarily or permanently?
Can you explain players in datastage?