what is meant by lookup caches?
Answers were Sorted based on User's Feedback
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|
Answer / swam
Yes..that's perfect answer from Swetha.
|Is This Answer Correct ?||1 Yes||0 No|
.prm wirh repalce .txt is possible?
What are the Differences between static cache and dynamic cache?
What is xml source qualifier transformation in informatica?
What is checksum termnology in informatica? Where do you use it ?
How informatica process data means how informatica works?
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…….
In real time scenario where can we use mapping parameters and variables?
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.
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..?
What is a pre-defined event and user-defined event?
what are the row and column separations in Flat Files
Can you copy the session to a different folder or repository?