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
- 7676 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 benefits of datastage?
How do you run datastage job from the command line?
Differentiate between data file and descriptor file?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Describe link sort?
What is job control?
What is the use of datastage designer?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How do you start developing a datastage project?
How to convert RGB Value to Hexadecimal values in datastage?
How do you remove duplicate values in datastage?
What is a quality stage in datastage tool?
how to write server Routine coding?
What are datastage sequences?
