The derivation for a stage variable is: Upcase(input_column1) : ‘ ‘ : Upcase(input_column2).
Suppose that input_column1 contains a NULL value. Which behavior is expected?

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

Records in a source file must be copied to multiple output streams for further processing. Which
two conditions would require the use of a Transformer stage instead of a Copy stage? (Choose
two.)

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?