Question: what is the difference between static and dynamic lookup in informatica?
Answer: Difference between static cache and dynamic cache? If you cache the lookup table, you can choose to use a dynamic or static cache. By default, the lookup cache remains static and does not change during the session. With a dynamic cache, the Informatica Server inserts or updates rows in the cache during the session.