vivek1708

 Profile Answers by vivek1708 

• May 7th, 2008

 

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.

ggazulas

 Profile Answers by ggazulas 

• May 27th, 2008

 

For a cached lookup the entire rows (lookup table) will be put in the buffer, and compare these rows with the incomming rows.

where as uncached lookup, for every input row the lookup will query the lookup table and get the rows.

gaurav2485

 Profile Answers by gaurav2485 

• Jan 8th, 2009

 

In Cache Lookup a cache will be created of that Lookup table and IS query once for mapping rows for Uncache lookup No cache will be build and IS query for each Mapping rows.
So for performance Go for Cache lookup if Lookup table size< Mapping rows
Go for UnCache lookup if Lookup table size> Mapping rows