Input rows to a Transformer contain a product name field and a field with a list of colors the
product can be ordered with. The colors are separated by the pipe character (|). Here is an
example of an input row: “Shirt”| ….| “Red, Blue, Black”|… For each input row, you want to output
multiple output rows, one for each color in the list. For the above example input row, three rows
are to be output, one per color: “Shirt” … “Red”, “Shirt” … “Blue”, “Shirt” … “Black”.
Which three operations will you need to accomplish this? (Choose three.)

A.
Use the Count() function over the ColorList field to determine the number of loop iterations.

B.
Use the LastRowInGroup() function to determine when the last color in the color list has been
processed.

C.
Use the @ITERATION variable to determine which color in the ColorList field to extract using
the Field function.

D.
Specify the following loop condition: @ITERATION <= n,where n is a stage variable initialized
with number of loop iterations.

E.
Use the SaveInputRecord() to save the input row for processing in the loop. Use the
GetInputRecord() to extract the row for each iteration of the loop.

Explanation: