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!
null input in transformer stage
Moderators: chulett, rschirm, roy
Re: null input in transformer stage
Could you explain that? NULL output columns are perfectly valid and are used all the time.cetzhbo wrote:...but if this null input columne appears in the output derivation, corresponding output will be rejected...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.