Which two statements about using a Load write method in an Oracle Connector stage to tables
that have indexes on them are true? (Choose two.)

Which Oracle Connector stage property can be set to tune job performance?

In a Transformer expression for a stage variable, there is a nullable input column. Assume the
legacy NULL processing option is turned off. What happens when a row is processed that contains
NULL in that input column?

When using the loop functionality in a transformer, which statement is true regarding Transformer
processing.

In your job you are using a Sequential File stage as a source. You have decided to use a schema
file as an alternative way of specifying column definitions and record format properties. What two
items are true in configuring this stage in your parallel job? (Choose two.)

Which stage classifies data rows from a single input into groups and computes totals?

Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?

Which derivations are executed last in the Transformer stage?

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 technique will enable you to retrieve the sum of
the last group?

The derivation for a stage variable is: Upcase(input_column1) : ‘ ‘ : Upcase(input_column2).
Suppose that input_column1 contains a NULL value. Assume the legacy NULL processing option
is turned off. Which behavior is expected?