Can I read Types of Lookup Caches in Informatica on EtoBox?

Types of Lookup Caches in Informatica is a document available to read on EtoBox.

What is Types of Lookup Caches in Informatica about?

A Lookup transformation is used to lookup data from a relational table, view, or synonym in an Informatica mapping. It compares values on lookup ports to columns in the lookup table based on a defined condition. The results are passed to other transformations and targets. A Lookup can be configured as cached or uncached, with caches improving performance by querying the cache instead of the database. Caches can be static, only using existing data, or dynamic, inserting new records from the target table.

Language

EN