jayadhar

• Sep 4th, 2006

 

static cache stores overloaded values in the memory and it wont change throught the running of the session

where as dynamic cache stores the values in the memory and changes dynamically duirng the running of the session used in scd types -- where target table changes and is cache is dynamically changes

ramakrishna.inf

 Profile Answers by ramakrishna.inf 

• Apr 21st, 2009

 

Static cache - It doesn't reflect changes once data is cached is known as static cache.

Dynamic cache - It reflect to changes at the time of running the session if any updates happen in source data.