IBM
C2090-303 · Question #49
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…
The correct answer is C. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator. See the full explanation below for the reasoning.
Question
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?
Options
- AOutput the sum that you generated each time you process a row for which the LastRow() function
- BOutput the sum that you generated up to the previous row each time you process a row with a "1" in the
- COutput a running total for each group for each row. Follow the Transformer stage by an Aggregator
- DOutput the sum that you generated up to the previous row each time you process a row with a "1" in the
How the community answered
(22 responses)- A9% (2)
- B14% (3)
- C73% (16)
- D5% (1)
Community Discussion
No community discussion yet for this question.