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

How do you migrate data from one environment to another?

641


How many transformations can be used in mapplets.

1454


Difference between Target-based loading and constraint-based loading?

548


What is the difference between informatica 7.0 and 8.0?

563


Performance tuning in UNIX for informatica mappings?

2135






Write the program through which the records can be updated?

510


Can we create a node as a gateway node and the same node can be assigned to a grid?

635


How to update source definition?

626


Explain sessions. Explain how batches are used to combine executions?

587


without table how to come first record only in oracle?

1847


my source is junk data how will u remove that junk data by using unix please any one replay me

3239


Differentiate between a database and data warehouse?

650


server hot-ws270 is connect to Repository B. What does it mean?

1853


Can we change Dynamic to Static or Persistent cache? If so what happens?

1724


How to generate or load values in to the target table based on a column value using informatica etl tool.

606