Multiple choice technology

The data required for the lookup is read from it’s source only once in a single session.

  1. True

  2. False

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

In Informatica, when a Lookup transformation uses caching (the default setting), the lookup source data is read once at session start and cached in memory for subsequent lookups throughout the session. This avoids repeated database queries and improves performance.