Static cache and dynamic cache are cache concepts and have almost no relation to any language. There are usually two types of searches.
Insecure search: we scan the base table and return output values based on the Lookup condition. If the search condition matches, it returns a value from the Lookup table or cache. And if the search condition is not met, it returns either NULL or the default value. Here's How Uncached Lookup Works
Cached Search . The Integration Service creates a cache whenever the first line in Lookup is processed. After the cache is created, the integration service always queries the cache instead of the lookup table. It saves a lot of time.
The search key can be of different types, such as dynamic cache and static cache
What is a static cache?
- Read only In the static cache, the integration service cannot update or insert into the cache during conversion processing.
- A static cache is similar to cached search, in which, after creating a cache, the integration service always requests a cache instead of a lookup table.
- In the static cache, when the Lookup condition is true, the return value from the lookup table returns Null or Default.
What is a dynamic cache?
- Read / write . In the dynamic cache, we can insert or update lines in the cache when passing lines.
- The Integration Service dynamically inserts or updates data in the search cache and passes data to the target.
- The dynamic cache is synchronized with the target.
source share