What are the types of lookup caches?
- 10 Answers
- 65521 Views
- Accenture, IBM, Informatica, I also Faced
- E-Mail Answers
Answer Posted / anushka jain
Lookup Cache boost the performance of look up by reading the data from lookup source only once and then using it for for rest of the mapping. We can enable the Cache by checking the “Lookup caching Enabled†in the Properties tab of lookup Transformation.
Different Type of Cache are
1.static cache
2.dynamic cache
3.persistant cache
4.shared cache
I found a very good article at below link .
http://www.tecktricks.com/types-of-lookup-cache-in-informatica/
I hope it will benefit you :)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are data-driven sessions?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Differentiate between router and filter transformation?
What are the tasks that source qualifier perform?
What is a stored procedure transformation?
What is depict expression change?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is meant by pre and post session shell command?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Have you worked with/created Parameter file
what is unit testing?tell me proceedure
can we override a native sql query within informatica? Where do we do it?
What is option by which we can run all the sessions in a batch simultaneously?
