By default lookup transformation is
-
Uncached
-
Cached and static
-
Cached and persistent
-
Uncached and static
B
Correct answer
Explanation
By default, Lookup transformation uses a static cache built at the beginning of the session and remains cached throughout. The cache is static (doesn't change during session) and cached (loaded into memory for faster access).