Interested to Buy Any Domain ? << Click Here >> for more details...
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...?
- 5 Answers
- 14551 Views
- TCS, I also Faced
- E-Mail Answers
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
Why fact table is in normal form?
What is oci?
What is meta stage?
How do you import and export data into datastage?
What are the steps needed to create a simple basic datastage job?
Have you used Unstructured data?
What is the difference between server job and parallel jobs?
What are the types of containers in datastage?
Why do we use link partitioner and link collector in datastage?
root tree will find which is server job and which is parallel job?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
how to write server Routine coding?
How do you generate sequence number in datastage?
Define Job control?
What are the types of hashed files in data stage
