In the exhibit, the Aggregator stage aggregates over CustomerID. The Join stage joins by
CustomerID. When the score is created, DataStage will insert hash partitioners and tsort operators
to ensure the correct results.
Which two choices will eliminate sort operators from being inserted at run-time? (Select two)

A.
Add a Sort stage before the Copy stage and specify Auto partitioned for the links going into the
Aggregator and Join stages.

B.
Add a Sort stage before the Copy stage and specify Same partitioners for the links going into
the Aggregator and Join stages.

C.
Add Sort stages in front of the Join stage and specify the Same partitionerfor the links going
into the Join. Set the $APT_NO_SORT_INSERTION environment variable to “True”.

D.
Add a Sort stage before the Aggregator stage and specify the Same partitioner for the link
going into the Aggregator Set the $APT_SORTJNSERTION_CHECK_ONLY environment variable
to “True”.

Explanation: