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 / sujana

if v cache the lukup..IS queries the cache for each row dat
eneters

if v dont cache IS queries the database for each row dat
enters..i.e issues a slect statemnt for each row

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps involved in the migration from older version to newer version of Informatica Server?

2042


Is it possible to create multiple domains on a single Informatica server?

1180


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1996


What is an Integration service in Informatica?

1081


Have you worked with/created Parameter file

1611


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2057


What is informatica powercenter repository?

1141


what is the Default Source Option For Update Strategy Transformation?

1166


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1628


What are the mapping parameters and mapping variables?

1087


What is a dimensional model?

927


What are the advantages of informatica?

957


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

1022


Explain the use of aggregator cache file?

1188


What is an unconnected transformation?

1033