A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
Answer Posted / tkm
1) Perform a bulk load into the target load.
2) If bulk load is already there, check whether the indexes (if any) in the target table are disabled or not.
3) Maybe you can check the configuration file to check how many nodes it is using and switch to a different configuration file having more number of nodes.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the stages in datastage?
Where do you see different stages in the designer?
What all the types of jobs you developed?
what is the use of surogate key in datastage
What is the project in datastage?
What are the various kinds of the hash file?
How many Key we can define in remove duplicate stage?
What are the different common services in datastage?
Why we use surrogate key?
Highlight the main features of datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Difference between in process and inter process?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Why fact table is in normal form?