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
- 14268 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
Name the different types of Lookups in Datastage?
Explain connectivity between datastage with datasources?
What is the difference between server job and parallel jobs?
What is the difference between orabulk and bcp stages?
What are transforms and what is the differenece between routines and transforms?
What is the difference between validated and compiled in the datastage?
How to reverse the string using SQL?
what is repositery?
What are the types of views in datastage director?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is the differentiate between data file and descriptor file?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is datastage engine?
What is the method of removing duplicates, without the remove duplicate stage?
