Multiple choice technology databases

In which of the transformation we can discard duplicate data?

  1. Source qualifier, Sorter

  2. Sorter, Joiner

  3. Joiner, Expression

  4. All of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Source Qualifier with 'Distinct' checked and Sorter transformation with 'Unique' property can both remove duplicate records. Source Qualifier filters duplicates at the source database level (SELECT DISTINCT), while Sorter eliminates duplicates after sorting in memory. Joiner does not remove duplicates, and Expression transforms individual rows without deduplication capability.

Keep practicing — related questions