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
- 7798 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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is aggtorec restructure operator?
How can we improve the performance in datastage?
What is "fatal error/rdbms code 3996" error?
What is oci?
Have you have ever worked in unix environment and why it is useful in datastage?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
What are the main differences you have observed between 7.x and 8.x version of datastage?
whom do you report?
What is a ds designer?
What are the different kinds of views available in a datastage director?
What are the difference types of stages?
Describe stream connector?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
