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

what is the diff b/w cached and unchaed look ups

Answer Posted / mike

well
Cached Lookup: In a lookup cache the entire rows will be
put in the buffer and then will be compared with the in
coming rows
where as
uncached lookup: In the uncahed lookup for every row the
lookup will query the lookup table to get the rows

correct me if i was wrong

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1129


What the difference is between a database, a data warehouse and a data mart?

1199


How many numbers of sessions can one group in batches?

1101


What is Index Caches size?

1163


Explain the use of aggregator cache file?

1316


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2300


What do you mean by enterprise data warehousing?

1107


On which transformations you created partitions in your project?

1431


is it possible to index the data in cache of lkp transformation ?

2074


Separate from a database, an information bazaar, and an information stockroom?

1126


What is an active transformation?

1159


What are the differences between source qualifier and joiner transformation?

1135


How to implement security measures using repository manager?

1234


How do you take back up of repository?

1207


How does the aggregator transformation handle null values?

1192