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...

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

Answer Posted / datastage4you

You can try to put a copy stage with force=True propertly. It can inhance the performance

http://goo.gl/atN4AT
www.datagenx.net

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe routines in datastage? Enlist various types of routines.

1017


What are stage variables, derivations and constants?

1239


What are the processing stages?

1108


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

2229


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

1756


What is the different type of jobs in datastage?

985


What is the difference between in process and inter process?

1161


What are the important features of datastage?

1137


Differentiate between Join, Merge and Lookup stage?

1102


How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2455


How will you move hashed file from one location to another location?

2165


How do you reject records in a transformer?

1133


How complex jobs are implemented in datstage to improve performance?

1054


what is repositery?

1854


Describe stream connector?

1313