what is lookup chache?

Answer Posted / mike

The informatica server builds a cache in the memory when it
process the first row of a cached lookup transformation.It
allocates the memory based on the amount you configure in
the trandformation or session properties.The informatica
server stores the conditional values in the index cache and
data values in the data cache..
correct me if i was wrong

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain scd type 3 through mapping.

676


What is the difference between informatics 7x and 8x and what is latest version?

651


What are the guidelines to be followed while using union transformation?

742


What is the use of code page?

691


Differentiate between source qualifier and filter transformation?

1118






Do you find any difficulty while working with flat files as source and target?

769


How are indexes created after completing the load process?

1094


What is powercenter on grid?

813


How does a rank transform differ from aggregator transform functions max and min?

787


What is a shortcut and copy in Informatica and how two are different with each other?

788


In informatica workflow manager, how many repositories can be created?

937


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1732


What are the basic requirements to join two sources in a source qualifier transformation using default join?

697


explain one complex mapping with logic? sales project?

6288


As union transformation gives UNION ALL output, how you will get the UNION output?

730