Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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...?

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

Differentiate between data file and descriptor file?

988


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

1833


Where the datastage stored his repository?

1018


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3130


Define orabulk and bcp stages?

1066


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1684


How can one find bugs in job sequence?

1316


Give an idea of system variables.

962


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3415


How complex jobs are implemented in datstage to improve performance?

962


What are system variables and sequencers in datastage

1067


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2324


What are sequencers?

1056


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

2166


in oracle target stage when we use load option and when we use upsert option?

2203