Multiple choice technology

Join component runs with inmemory option will have the output sorted on the Join key

  1. True

  2. False

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

The in-memory join option builds a hash table from one input for faster lookup, not for maintaining sort order. Hash-based joins provide O(1) lookup but don't preserve sorted output. If you need sorted output, you must explicitly add a Sort component after the join.