1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What are the types of lookup caches?

Question Posted / anushka jain

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


Please Help Members By Posting Answers For Below Questions

What is the need of an ETL tool?

731

Explain Dataware house architecture .how data flow from intial to end?

2209

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8928

How does the aggregator transformation handle null values?

801

Name at least 5 different types of transformations used in mapping design and state the use of each.?

782




In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1624

What are the new features of Power Center 5.0?

1336

How to do unit testing in informatica?

832

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

715

Why do we need informatica?

643

What are the informatica performance improvement tips

705

How do you convert single row from source into three rows into target?

732

Explian the Process of deployment groups in informatica

730

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1618

expain about the tune parameters?

2006