Interested to Buy Any Domain ? << Click Here >> for more details...
what are Lookup caches options? Including persistent caches.
- 1 Answers
- 4680 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhishek.x.upadhyay
There are two types of Lookup Cache options -
1. Dynamic cache.
2. Persistent cache
1. dynamic Cache - The Dynamic cache is a property of the
look up which if selected makes other ports of the same
record to be checked as Look up apart from the Look up port.
2. Persistent Cache - persistent cache is something like on
the first run the lookup table values gets into a cache and
is stored on the server's hard disk. Each time the run is
made the values would be looked up from this cache only.
Persistent cache is done only when the lookup has to be
made on same set of values each time.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the etl testing operations includes?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what are Lookup caches options? Including persistent caches.
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
list and discuss two approaches for updation of target table in Informatica and how they are different.
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
when will use SQL override in a lookup transformation?
what are the session parameters? How do u set them?
what is pmrep command?
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
what is granularity in Data ware House?
What is data cleaning?
What is the difference between Data Warehousing and Data Mining?
How many steps etl contains?
