Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 7529 Views
- IBM, I also Faced
- E-Mail Answers
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 different options associated with dsjob command?
How rejected rows are managed in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
What is job control?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What are the repository tables in datastage?
Name the command line functions to import and export the DS jobs?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
explain about citrix scheduling tool in datastage
What are the benefits of datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are the primary usages of datastage tool?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How can you write parallel routines in datastage PX?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
