You are processing groups of rows in a Transformer. The first row in each group contains “1” in
the Flag column and “0” in the remaining rows of the group. At the end of each group you want to
sum and output the QTY column values. Which three techniques will enable you to retrieve the
sum of the last group? (Choose three.)
A.
Output the sum that you generated each time you process a row for which the LastRow()
function returns True.
B.
Output the sum that you generated up to the previous row each time you process a row with a
“1” in the Flag column.
C.
Within each group sort the Flag column in ascending order. Output the sum each time you
process the row with a “1” in the Flag column.
D.
Output a running total for each group for each row. Follow the Transformer stage by an
Aggregator stage. Take the MAX of the QTY column for each group.
E.
Output the sum that you generated up to the previous row each time you process a row with a
“1” in the Flag column. Use the LastRow() function to determine when the last group is done.
Explanation: