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

I have a flat file, want to reverse the contents of the flat file

680


Which transformation should we use to normalise the COBOL and relational sources?

736


How to update a particular record in target with out running whole workflow?

1147


What is the command used to run a batch?

563


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

640






Explain direct and indirect flat file loading (source file type) - informatica

811


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5749


What is target designer and target load order?

645


Mention a few design and development best practices for informatica?

549


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

589


How can you define user defied event?

608


What is powercenter on grid?

682


Design a mapping to load the cumulative sum of salaries of employees into target table?

884


What is the reusable transformation?

616


What are the different clients of powercenter?

587