Multiple choice technology platforms and products

Which sort stage option can be selected to sort a dataset to retain a single occurance of multiple records that have identical sorting key values?

  1. Unique sort keys must be set to True

  2. Allow Duplicates must be set to False

  3. Sort Group must include the sort key values

  4. Stable sort must be set to true

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

In the DataStage Sort stage, setting the 'Allow Duplicates' property to False ensures that only a single occurrence of multiple records with identical sorting keys is retained.