Multiple choice technology databases

Which is not true regarding unconnected lookup?

  1. It does not contain return port

  2. Executed for every record passed

  3. Works only when lookup function is called

  4. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Unconnected lookup is only executed when the lookup function is explicitly called from an expression, unlike connected lookup which runs for every input row. It must have a Return port to pass the value back, and it is not executed automatically for each record passed through the mapping. This on-demand execution makes unconnected lookup more efficient for conditional lookups.

Keep practicing — related questions