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

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  


What is a code page?

0 Answers  


What is hash partition?

1 Answers  


how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,


In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,






what is upstream and downstream transformation?

7 Answers  


What are the different types of Type2 dimension maping?

2 Answers   CTS,


What are the two modes of datamovement in informatica sever?

2 Answers  


Explain how many types of dimensions are available in informatica?

0 Answers  


While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,


What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,


I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  


Categories