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

gaurav2485

 Profile Answers by gaurav2485 Questions 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 C...

ggazulas

 Profile Answers by ggazulas Questions 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.

Answer Question  Select Best Answer