what are Lookup caches options? Including persistent caches.
- 1 Answers
- 2078 Views
- I also Faced
- E-Mail Answers
Answer / Devendra Giri
Lookup Cache Options in Informatica PowerCenter are used to control the behavior of the cache for Lookup transformations. They can help improve performance by reducing I/O operations and memory usage.nnOptions include:
1. Cache Size: This determines how much memory is allocated for storing the cache.
2. Cache Type: This option allows you to choose between various types of caches, such as Session Cache, Repository Cache, and Persistent Cache.
3. Cache Mode: This setting specifies when the cache should be refreshed (Never, On Error, or Always).
4. Persistent Cache: This type of cache stores the lookup results across sessions. It can be configured using the Workflow Manager or by editing the $INFA/etc/cache_config.xml file.
| Is This Answer Correct ? | 0 Yes | 0 No |
how do u set partition points in the mapping?
what is the use of structures?how many nodes can u create in a structure?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what is the use of server?
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
what are the different Reporting and ETL tools available in the market?
What is staging area referring to?
What is cube grouping?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
In Which Transformation We Can Use Having Clause In Informatica?
how do u implement configuration management in Informatica?
what are the facilities provided by OLAP to analytical users?
Teradata 
