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 |
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
What is a filter transformation?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
Label in Informatica. How to remove existing Label.
What are the main issues while working with flat files as source and as targets ?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
Describe the impact of several join conditions and join order in a joiner transformation?
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
what is the monster dimension plz give me one example