null input in transformer stage

[cetzhbo]

Hello Gurus,

in transformer stage, if a input columne is null, and this is direct mapping, so corresponding output should be null.

but if this null input columne appears in the output derivation, corresponding output will be rejected.

how to make this null input column output with derivation if I want to keep this null value ?

thanks very much!

[ArndW]

...but if this null input columne appears in the output derivation, corresponding output will be rejected...

Could you explain that? NULL output columns are perfectly valid and are used all the time.

[cetzhbo]

this is the abstract for v8 guide:

" If you use input columns in an output column expression, be aware that a null value in that input column will cause the row to be dropped or, if a
reject link has been defined, rejected. "

my question point to that.

thanks very much!

[ray.wurlod]

This refers to the case where the output column is designated as Not Null, or where the output column derivation expression includes a function that does not tolerate null arguments (which is the case for most of the functions).