Difference between static and dynamic cache
Static- Once the data is cached , it will not change. example unconnected lookup uses static cache.
Dynamic- The cache is updated as to reflect the update in the table( or source) for which it is reffering to.(ex. connected lookup).   _{Your Comment}