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
- 13179 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
What are routines in datastage?
Name the third party tools that can be used in datastage?
project Steps,hits, Project level HArd things,Solved methods?
What are system variables and sequencers in datastage
in oracle target stage when we use load option and when we use upsert option?
How do you generate sequence number in datastage?
What are the different layers in the information server architecture?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What are the types of jobs we have in datastage?
What are the types of views in datastage director?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Explain entity, attribute and relationship in datastage?
Does datastage support slowly changing dimensions ?
Highlight the main features of datastage?
What are stage variables and constants?
