The given job processes large volumes of data using default partitioning, with sort/partition
insertion enabled. Both source Data Sets are partitioned and sorted on the merge key. Assuming
that the business logic allows all of the following actions, which design change would improve the
performance of this job?

A.
Set the buffer mode to “no buffer” on the output links of both Data Sets.

B.
Use the Data Set Management Utility to combine both input Data Sets into a single source Data
Set.

C.
Set the “Preserve Partitioning” option on both Data Sets and replace the Merge stage with a
Sort Funnel stage.

D.
Before each input to the Merge stage,insert a Sort stage with “Don’t Group,Previously
Grouped” set on the merge key. Specify SAME partitioning on all inputs.

Explanation:

Topic 3, Volume C