Records in a source file must be aggregated for further processing. Which two conditions would
require the use of a Transformer stage instead of or in addition to an Aggregator stage? (Choose
two.)

Which two statements are true about DataStage Parallel Build stages? (Choose two.)

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

In a Transformer Stage you have a nullable input column that is mapped to a non-nullable output
column. What two techniques can be used to handle NULL values? (Choose two.)

Which three statements are true about stage variables in a Transformer Stage? (Choose three.)

What role must a user have to delete shared metadata assets from the repository?

Which three of the following are valid schema formats? (Choose three.)

How is DataStage Table Metadata shared among DataStage projects?

What are two advantages of using Runtime Column Propagation (RCP)? (Choose two.)

You are using the Change Capture stage in your job design to identify changes made to the input
link (before image) to obtain the results in the output link. This job will be using a multi-node
configuration file when executed. By default, the Change Capture stage produces an output
change link with which two characteristics? (Choose two.)