Multiple choice technology databases

By using unconnected lookup how many rows can be returned?

  1. 0

  2. 1

  3. 2

  4. Any Number
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Unconnected lookup transformations in Informatica can return only one row per lookup operation. This is a fundamental limitation - when you configure an unconnected lookup, it returns the first matching row based on the lookup condition. If multiple rows match, only one is returned. Connected lookups differ as they process data row-by-row within the data flow.

Keep practicing — related questions