A scenario requires selecting only the most recent transactions for each of 2 million unique
customers, from a 20 million row DB2 source table containing order history. Which parallel job
design would satisfy this functional requirement?
A.
Using the Dynamic Relational stage,use custom SQL to select all DISTINCT customer numbers
from the order history table.
B.
Select all rows using the ODBC Connector stage,use a Sort Aggregator on customer number
key to select the maximum order date.
C.
Using the DB2 Enterprise stage,select all rows. Perform a unique Sort using customer number
and order date sort keys in ascending order.
D.
Using the DB2 API stage,select all rows. Use a Sort stage with customer number and order
date sort keys in ascending order,then Remove Duplicates with Last Duplicate to retain.
Explanation: