A customer wants to select the entire order details for the largest transaction for each of 2 million
customers from a 20 million row DB2 source table containing order history. Which parallel job
design would satisfy this functional requirement?
A.
Partition on customer key,sort on customer key and transaction amount,remove duplicates on
customer key.
B.
Use a Sort Aggregator stage with calculated column based on the maximum value of
transaction amount column.
C.
Partition and sort the input to a Filter stage by customer number. Filter with the clause
“MAX(transaction_amount)”.
D.
Partition and sort the input to a RemoveDuplicates stage using the customer key and
transaction amount columns. Remove duplicates on customer key.
Explanation: