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

What is data transformation manager process?

1222


What are data-driven sessions?

1261


What are the types of caches in lookup? Explain them.

1013


What do you understand by SOA of Informatica?

1043


How can we handle two sessions in informatica?

1094


How to do the error handling of if ur source is flatfiles?

2023


What is the Process to creating lookup transformation in informatica

1090


How to use procedural logic inside infromatica?

1323


What is decode in static cache?

1263


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4779


Can informatica load heterogeneous targets from heterogeneous sources?

1235


can u any challenge your project?

2085


How does a rank transform differ from aggregator transform functions max and min?

1263


What is substr in informatica?

1261


What is a sequence generator transformation?

1075