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?
A.
The job aborts.
B.
NULL is written to the target stage variable.
C.
The input row is either dropped or rejected depending on whether the Transformer has a reject
link.
D.
The target stage variable is populated with spaces or zeros depending on the stage variable
data type.
Explanation: