A job needs to split a single Data Set into three Data Sets based on conditions that are supplied at
runtime. Which stage would allow you to parameterize the conditions for splitting the input data
set?

In a Transformer expression for a stage variable, there is a nullable input column. What happens
when a row is processed that contains NULL in that input column?

A star schema data warehouse consists of four dimension tables and one fact table. How many
Slowly Changing Dimensions (SCD) stages will you need in your jobs to update the star schema

tables?

Which two statements are true about DataStage parallel routines? (Choose two.)

Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)

Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product
column. Using stage variables, how can you determine when a new row is the first of a new group
of Product rows?

Which of the following describes what happens when Runtime Column Propagation is enabled?

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