Multiple choice technology platforms and products

Which of the following are types of lookup cache?

  1. Static cache

  2. Dynamic cache

  3. Shared cache

  4. All the above

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Informatica Lookup transformation supports three cache types: Static cache (built once and reused), Dynamic cache (cache updated during session - used for lookups that change), and Shared cache (shared across multiple transformations). Since all three are valid types, 'All the above' is the correct answer. Static is default and fastest. Dynamic is slower but needed when lookup data changes during session. Shared allows multiple lookups to share the same cache to save memory.