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
What is a merge in datastage?
Differentiate between odbc and drs stage?
Can you explain players in datastage?
What is apt_config in datastage?
Difference between in process and inter process?
how to implement scd2 in datastage 7.5 with lookup stage
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is oci?
What is the difference between the local container and shared container?
Which warehouse using in your datawarehouse
What are the important features of datastage?
What is datastage?
Define Data Stage?
AGGREGATOR default datatype
What is the difference between operational data stage (ods) and data warehouse?