what is lookup chache?



what is lookup chache?..

Answer / 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

More Informatica Interview Questions

Explain about cumulative Sum or moving sum?

0 Answers   Informatica,


i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

7 Answers   L&T,


Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,


How do you handle two sessions in Informatica

0 Answers   Informatica,


How to use pmcmd utility command?

0 Answers  






Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,


what is mapping parameter?

2 Answers   Cap Gemini,


difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,


what is workflow varible

1 Answers   HP,


What is the use of an aggregator cache file?

0 Answers  


CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?

6 Answers  


How the Informatica Server reads perameter file?

1 Answers  


Categories