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 |
can you use flat file for lookup table?why?
What are the rank caches?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is the difference between Active and Passive transformation?
What is pmcmd command?
Why sorter is an active transformation?
major difference between normal loading and bulk loading?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Design a mapping to load a target table with the following values from the above source?
What is the functionality of update strategy?
What are mapplets?