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. Specify the following loop condition: @ITERATION <= n, where n is a stage variable initialized with 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 Count() function over the ColorList field to determine the number of loop iterations.
• D. Use the @ITERATION variable to determine which color in the ColorList field to extract using the Field function.
• 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.

Refer to the exhibit.

You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the command "ps-ef | grepds" and receive the following screen:
Which process is the section leader for node2?

• A. 7216
• B. 7219
• C. 7221
• D. 7220

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 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.
• 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 each time you process a row for which the LastRow() function returns True.
• E. 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.

Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?

• A. Log onto the server and issue the command "ps -ef | grep ds".
• B. Set $APT_PM_SHOW_PIDS to true.
• C. Set $APT_DUMP_SCORE to true.
• D. Use the DataStage Director Job administration screen to display active player processes.

There is a requirement to load mainframe data with array columns having redefined fields into a flat file. How can the Complex Flat File

• A. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected. Select the array with redefine column(s) and click redefine check box option.
• B. Within CFF, use the Complex File Load Option window with "Flatten all arrays" option selected. CFF will handle flattening automatically.
• C. CFF does not support flattening for redefined fields.
• D. Select the Records ID tab on the Stage page. Select a record from the Records list. Select the column(s) with the redefine from the Column list. Within CFF, use the Complex File Load Option window with "Flatten selective arrays" option selected.