Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is meant by lookup caches?

Answers were Sorted based on User's Feedback



what is meant by lookup caches?..

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

what is meant by lookup caches?..

Answer / swam

Yes..that's perfect answer from Swetha.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

.prm wirh repalce .txt is possible?

2 Answers  


What are the Differences between static cache and dynamic cache?

1 Answers  


What is xml source qualifier transformation in informatica?

0 Answers  


What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,


How informatica process data means how informatica works?

2 Answers   TCS,






My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,


In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,


Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,


If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  


What is a pre-defined event and user-defined event?

0 Answers  


what are the row and column separations in Flat Files

3 Answers   CTS,


Can you copy the session to a different folder or repository?

2 Answers  






Categories