nerdexam
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)
  • A
    8% (3)
  • B
    79% (31)
  • C
    3% (1)
  • D
    10% (4)

Community Discussion

No community discussion yet for this question.

Full C2090-303 Practice