i have seq file that contents 10 million records load to target any data base..
in that case it takes lot of time for loading..how do performance tuning in that situation...?
Answer Posted / prasad
In Seq file, we have one property called no. of readers/node(by default is one)=4 and
in Target table use "Bulk load" and also use Round Robin partition.
first drop index before loading data and once data loaded then re-create index again.
Plz correct me, if i am wrong.....
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between odbc and drs stage?
What is aggtorec restructure operator?
what is use of SDR function?
what is the use of skid in reporting?
What is the difference between an operational datastage and a data warehouse?
Define data aggregation?
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 you Implemented SCD Type 1 & Type 2 in your project?
how to write server Routine coding?
what is the use of surogate key in datastage
Explain the importance of surrogate key in data warehousing?
Demonstrate experience in maintaining quality process standards?
What is usage analysis in datastage?
What is the different type of jobs in datastage?
How can one find bugs in job sequence?