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

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

Answer Posted / vivek

I think before sending
data from the source if we
sort the data by sql
override i.e by adding a
"order by" clause in
default sql querry then
our problem wil be solved.

Is This Answer Correct ?    0 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain target update override in informatica

1126


How is union transformation utilized?

1009


How to partition the Session?

1113


How to load the data from a flat file into the target where the source flat file name changes daily?

1056


Which transformation should we use to normalise the COBOL and relational sources?

1208


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1032


What is informatica metadata and where is it stored?

991


What is mapping debugger?

1012


define galaxy repository in informatica

2228


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2420


Where is metadata stored?

1112


Describe an informatica powercenter?

1127


What is the benefit of session partitioning?

1116


Different sorts of metadata that stores in the storage facility?

1010


What is a pre-defined event and user-defined event?

1037