The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)
The Lookup stage is one of three stages that join records based on the values of key columns. What are the other stages? (Choose two.)
The Lookup stage is indeed used to join records based on key column values. The other stages that perform similar joining operations are the Join stage and the Merge stage. The Join stage combines records from two input links by performing a relational join. The Merge stage combines records from multiple input links based on key columns and produces a merged output. Therefore, the correct options are Join and Merge.
Correct Answer: AB