Informatica Lookups can be cached or un-cached (No cache) and Cached lookup can be either static or dynamic.
A static cache is one which does not modify the cache once it is built and it remains same during the session run. On the other hand, A dynamic cache is refreshed during the session run by inserting or updating the records in cache based on the incoming source data. By default, Informatica cache is static cache.
A lookup cache can also be divided as persistent or non-persistent based on whether Informatica retains the cache even after the completion of session run or deletes it
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!