PrepAway - Latest Free Exam Questions & Answers

Which behavior is expected?

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply