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


Please Help Members By Posting Answers For Below Questions

Can you explain link buffering?

723


What are the components of ascential data stage?

645


Could anyone give brief explanation bout datastage admin

1963


If you want to use the same piece of code in different jobs, how will you achieve it?

628


which r the connectors used in san?

1784






What are datastage sequences?

663


What are system variables and sequencers in datastage

602


describe the Steps to confiure a Qlogic switch

1931


how can we create rank using datastage?what is the meaning of rank?

8157


Define oconv () and iconv () functions in datastage?

871


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3752


What are the functionalities of link partitioner?

610


What are the functionalities of link partitioner and link collector?

594


Triggers,VIEW,Procedures

790


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1754