Multiple choice technology

Method to compare data in two tables

  1. Lookup

  2. Minus

  3. Either a or b is sufficient

  4. Both a and b are needed

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

Both Lookup transformation and SQL MINUS operator can effectively compare data between two tables. Lookup joins sources for row-by-row comparison, while MINUS finds set differences. Either approach is sufficient for comparison tasks.