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 are the various tools used in etl?
Eliminating of duplicate records without using dynamic lookups
What is the main difference between peek stage and copy stage
What exact we can see in table?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
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 do use session mapping parameters ?(in which transformation)
Explain and compare etl & manual development?
State the differences between shortcut and reusable transformation
What are dimensions?
what are the different Reporting and ETL tools available in the market?