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
- 14348 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
State the difference between an operational datastage and a data warehouse?
What is the difference between validated and compiled in the datastage?
Terminate Activity
What are the different options associated with dsjob command?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the flow of loading data into fact & dimensional tables?
What is the precedence of stage variables,derivations, and constraints?
What is the difference between in process and inter process?
Explain Quality stage?
What are the different common services in datastage?
Lookup constraints
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What steps should be taken to improve Datastage jobs?
What are constraints and derivations?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
