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 to increase performance without changing anything in mapping.( In prod)
hoe to access second value in mapping parameter if it is having more than one value ?????????????
what are the data modeling tools you have used?(polaris)
what are the session parameters? How do u set them?
What are the differences between sql override and update override?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
how would u estimate the size of Aggregator transform data and index cache?
How many steps etl contains explain with example?
dimension object created in oracle can be imported in designer?how?
what are the facilities provided by data warehouse to analytical users?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
Explain etl?
Explain about etl data integration software?
what are the reporting tools and difference between them?
Explain what is etl process? How many steps etl contains explain with example?