Multiple choice technology

How the duplicate rows are treated in sorter transformation

  1. a. duplicate rows are sorted based on the case.

  2. b. You can configure the Sorter transformation to treat output rows as distinct.

  3. c. The Integration Service rejects duplicate rows compared during the sort operation.

  4. d.none of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Sorter transformation can be configured with the 'Distinct' output option to treat output rows as distinct, removing duplicates during the sort operation. When enabled, the Sorter uses the sort key columns to identify and eliminate duplicate rows, passing only unique rows to downstream transformations. This is more efficient than using an Aggregator or Expression transformation after sorting to remove duplicates. The other options are incorrect: duplicates are not rejected, they can be eliminated; there's no case-based duplicate sorting behavior.

Keep practicing — related questions