what is meant by lookup caches?

Answer Posted / swetha

The informatica server builds a cache in memory when it
processes the first row af a data in a cached look up
transformation. It allocates memory for the cache based on
the amount you configure in the transformation or session
properties. The informatica server stores condition values
in the index cache and output values in the data cache.

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by enterprise data warehousing?

646


What are the main issues while working with flat files as source and as targets ?

657


can anyone suggest best free Talend data integration training online

1263


What is the scenario which compels informatica server to reject files?

606


Different qualification between a related rotate toward the sky and isolates look upward?

556






What is informatica?

682


What is a repository manager?

648


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1789


can we override a native sql query within informatica? Where do we do it? How do we do it?

600


What will be the approach?

582


what is unit testing?tell me proceedure

1782


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3511


Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2430


How to extract the informatica rejected data?

757


What is InformaticaPowerCenter?

692