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 |
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
I have source like this 1:2;3. so i want to load the target as 123
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
What is DTM process?
What is the maplet?
Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you
What is the difference between a table and the materialized view?
How do you migrate data from one environment to another?
in which situations do u go for sequence generator ?
Explain about Recovering sessions?