Multiple choice technology

What is the difference between connected and unconnected look up and which performs better?

  1. A connected look up can return only one port within the data flow. An unconnected look up is used when multiple values are to be returned

  2. A connected look up can return multiple ports within the data flow. An unconnected look up is used when only one value is to be returned

  3. the performance of unconnected look up is lower than connected lookup

  4. the performance of connected look up is lower than unconnected lookup
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

Connected lookups participate in the data flow and can return multiple port values through a single lookup call, while unconnected lookups are called from expressions using :LKP syntax and return only one value. Unconnected lookups generally perform better because they're only executed when needed (cached results possible) and don't require continuous connection to the lookup source during data flow processing.

Keep practicing — related questions