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
- 12588 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
How to find value from a column in a dataset?
What are system variables and sequencers in datastage
What is the method of removing duplicates, without the remove duplicate stage?
State the difference between an operational datastage and a data warehouse?
Give an idea of system variables.
Distinguish between informatica & datastage. Which one would you choose and why?
What are the various kinds of the hash file?
How to manage date conversion in Datastage?
Enlist various types of routines in datastage.
Difference between server jobs & parallel jobs?
What is the difference between hashfile and sequential file?
What is the difference between an operational datastage and a data warehouse?
describe the Steps to confiure a Qlogic switch
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
