what are Lookup caches options? Including persistent caches.
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 |
what is a worklet?
what is an ETL or ETT? And what are the different types?
what is the indicator file and where it is used?
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?
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
how do u implement scheduling in Informatica?
what is the difference between normal & bulk loading? and which one is recommended ? why?
Explain the use lookup tables and Aggregate tables?
if i have a query as flat file how can we load data to target table
What is a materialized view log?