What are the types of lookup caches?
- 10 Answers
- 65579 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
Explain the mapping variable usage example in informatica
Can we override a native sql query within informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How many input parameters can exist in an unconnected lookup?
What is meant by query override?
What are the different types of olap? Give an example?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Mention some types of transformation?
What is the commit type if you have a transaction control transformation in the mapping?
How you can differentiate between connected lookup and unconnected lookup?
What are active and passive transformations?
Explain about Informatica server process that how it works relates to mapping variables?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is the benefit of partitioning a session?
What are the advantages of informatica?
