Lookups can either be uncached or cached. Cached lookups are further divided into static or dynamic. Static cache remains constant throughout the session run and once built doesn’t change the cache. Dynamic cache refreshes during the session runs by updating or inserting cache records depending upon input source data. Lookup caches are also differentiated as persistent and non persistent depending on if Informatica preserves the cache post session runs.
