What Is The Difference Between Static Cache And Dynamic Cache?
Ch KashifEnlightened
Power BI
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this answer should be reported.
What Is The Difference Between Static Cache And Dynamic Cache?
Ch Kashif
In case of dynamic cache, when we are inserting a new row it checks the lookup
cache to see if it exists, if not inserts it into the target as well as the cache but in case
of static cache the new row is written only in the target and not the lookup cache.
The lookup cache remains static and does not change during the session but incase
of dynamic cache the server inserts, updates in the cache during session.