Hi all,
My Job is having ODBC stage --> and T/F stage--> sequential stage.
I have to handle the null values if it comes from database to either empty or to a value. I handled them using IsNull(i/pcolumn) in T/F stage.
but in output those values are not reflecting and are dropped with a warning message "Field '*****' from input dataset '0' is NULL. Record dropped."
Could any one suggest me why it is so.
for all my previous projects I use to do the same and those are working fine.
Null values are dropped in the tranformer stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Fri Oct 22, 2010 7:08 am
Null values are dropped in the tranformer stage
Thanks & Regards,
Bhanu
Bhanu
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
Re: Null values are dropped in the tranformer stage
Try to use NullToValue function in a transformer stage.You can also do it in a modify stage
Soumya