Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by lookup caches?
- 2 Answers
- 11052 Views
- Cap Gemini, Informatica, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to create Target definition for flat files?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Explain transaction control transformation in informatica
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to load a Dimension ? and how to load a fact table?
What can we do to improve the performance of informatica aggregator transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
When do you use sql override in a lookup transformation?
How can we create index after completion of load process?
What is Index Caches size?
What is the Rank index port in Rank transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the surrogate key?
