PrepAway - Latest Free Exam Questions & Answers

Which technique will enable you to retrieve the sum of the last group?

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 technique will enable you to retrieve the sum of
the last group?

PrepAway - Latest Free Exam Questions & Answers

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.
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.

D.
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 FirstRow()
function to determine when the group is done.

Explanation:


Leave a Reply