I am getting following warning in the transformer stage before loading into final dataset
xfm_tranformer,0:Field XXX from input dataset '0' is NULL. Record dropped.
and the output datatype is : Varchar2(52)
Null handel
Moderators: chulett, rschirm, roy
Re: Null handel
First thing this is a common error and you will find enough material on this in dsxchange. Type Null handling in search, and you will get info.
As for the problem, just check if the column which is giving this error is used in any transformation, also use null handling in the stage variables for this column
i.e id isNull(Columnname) Then '' Else Columname, based on your requirement
As for the problem, just check if the column which is giving this error is used in any transformation, also use null handling in the stage variables for this column
i.e id isNull(Columnname) Then '' Else Columname, based on your requirement
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 50
- Joined: Fri Dec 21, 2007 3:24 am