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 can eliminate duplicates at the source level using the 'Select Distinct' option, while Sorter transformation can remove duplicates from the pipeline after sorting. Joiner does not remove duplicates - it combines data from different sources. Expression transformation only performs row-level calculations without duplicate handling capability.

Keep practicing — related questions