IBM
C2090-303 · Question #50
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…
The correct answer is B. NULL is written to the target stage variable. See the full explanation below for the reasoning.
Question
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?
Options
- AThe job aborts.
- BNULL is written to the target stage variable.
- CThe input row is either dropped or rejected depending on whether the Transformer has a reject link.
- DThe target stage variable is populated with spaces or zeros depending on the stage variable data type.
How the community answered
(39 responses)- A8% (3)
- B79% (31)
- C3% (1)
- D10% (4)
Community Discussion
No community discussion yet for this question.