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...?
Answer Posted / subhash
One more Option is split the file into small files and Load
all files and send those to funnel to combind.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between data file and descriptor file?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Where the datastage stored his repository?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Define orabulk and bcp stages?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How can one find bugs in job sequence?
Give an idea of system variables.
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How complex jobs are implemented in datstage to improve performance?
What are system variables and sequencers in datastage
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are sequencers?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
in oracle target stage when we use load option and when we use upsert option?