How does the Complex Flat File stage (CFF) support the use of “OCCURS DEPENDING ON”
clause?

What two stages are required to place Header and Detail records, which have different formats,
into a single format? (Choose two.)

In a file defining a partial schema, which three properties define the record? (Choose three.)

How are Shared Table definitions created from the DataStage Client?

How is Runtime Column Propagation (RCP) enabled for use in DataStage Jobs?

What three element Names are required to create Shared metadata? (Choose three.)

Which condition is required to use the LastRowInGroup() function to determine a key break on a
field?

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