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 |
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
how do u implement scheduling in Informatica?
what is Forward,Reverse and Re_engineering?
what is the difference between date cache and lindex cache?
what is data modeling?
Explain the key challenges that you face while performing etl testing.
what is the meant by Normalization and de-normalization?
how do u set partition points in the mapping?
what is an ETL or ETT? And what are the different types?
SCD2 will work on only dimension tables as well as fact Table?
What are snapshots?