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 / datastage4you
You can try to put a copy stage with force=True propertly. It can inhance the performance
http://goo.gl/atN4AT
www.datagenx.net
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Describe routines in datastage? Enlist various types of routines.
What are stage variables, derivations and constants?
What are the processing stages?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is the different type of jobs in datastage?
What is the difference between in process and inter process?
What are the important features of datastage?
Differentiate between Join, Merge and Lookup stage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How will you move hashed file from one location to another location?
How do you reject records in a transformer?
How complex jobs are implemented in datstage to improve performance?
what is repositery?
Describe stream connector?