Answer Detail: RE: Cached Lookup and an Uncached Lookup

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: Cached Lookup and an Uncached Lookup

Answer: What is the difference between using a cached lookup and an uncached lookup?

May 05, 2008 23:59:57	#1
vivek1708	Member Since: May 2008 Total Comments: 18
RE: Cached Lookup and an Uncached Lookup
while using a cache lookup, a pre-fetch is performed on the lookup table, before the mapping is executed. Uncached lookup is like any normal look up.