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 are Lookup caches options? Including persistent caches.



what are Lookup caches options? Including persistent caches...

Answer / abhishek.x.upadhyay

There are two types of Lookup Cache options -

1. Dynamic cache.
2. Persistent cache

1. dynamic Cache - The Dynamic cache is a property of the
look up which if selected makes other ports of the same
record to be checked as Look up apart from the Look up port.

2. Persistent Cache - persistent cache is something like on
the first run the lookup table values gets into a cache and
is stored on the server's hard disk. Each time the run is
made the values would be looked up from this cache only.

Persistent cache is done only when the lookup has to be
made on same set of values each time.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More ETL Interview Questions

what is a worklet?

0 Answers  


what is an ETL or ETT? And what are the different types?

0 Answers  


what is the indicator file and where it is used?

1 Answers  


1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

0 Answers  


Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com

320 Answers   Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,


Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

1 Answers   IBM, Saama Tech, Wipro,


diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

0 Answers   L&T,


how do u implement scheduling in Informatica?

1 Answers   Cognizant,


what is the difference between normal & bulk loading? and which one is recommended ? why?

2 Answers  


Explain the use lookup tables and Aggregate tables?

0 Answers  


if i have a query as flat file how can we load data to target table

0 Answers   Tech Mahindra,


What is a materialized view log?

0 Answers  


Categories