1.
Which DB2 to InfoSphere DataStage data type conversion is correct when reading data with the DB2 Connector stage?
2.
Which Oracle data type conversion is correct?
3.
Which Oracle Connector stage property can be set to tune job performance?
4.
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?
5.
When using the loop functionality in a transformer, which statement is true regarding Transformer processing.
6.
Which stage classifies data rows from a single input into groups and computes totals?
7.
Which statement describes a SCD Type One update in the Slowly Changing Dimension stage?
8.
Which derivations are executed last in the Transformer stage?
9.
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?
10.
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?