what are Lookup caches options? Including persistent caches.
Answer Posted / 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 View All Answers
how many maximum session supports to multiload in teradata ??
What is lookup table in etl testing?
how do u set partition points in the mapping?
What is etl process? How many steps etl contains?
Explain about etl data integration software?
What are the different etl testing categories as per their function?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how do u extract data from different data sources explain with an example?
Explain about enterprise scalability and roi of data integration suite?
what is a worklet?
When do we analyze the tables?
how do u implement configuration management in Informatica?
what is pmrep command?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
What is initial load and what is full load?