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
- 14073 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
Can we use target hash file as a lookup ?
What is oci?
Differentiate between Join, Merge and Lookup stage?
how to implement scd2 in datastage 7.5 with lookup stage
Describe the architecture of datastage?
Difference between sequential file and data set?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Different ways a project can be moved to production ?...example ….export-import and Version control.
What are the types of views in datastage director?
What is the difference between orabulk and bcp stages?
Difference between server jobs & parallel jobs?
What is the use of datastage designer?
what is repositery?
What are routines in datastage? Enlist various types of routines.
To see hidden files in LINIX?
