Hi All,
I'm having input column order_nbr(decimal9,0) nullable but while loading this to target i'm handling null values by using modify stage function as Handle_Null(order_nbr,"").But is giving error message as "Bad literal for type decimal: ."
Please let me know what is wrong in the above?
Thanks & Regards,
Kalpana.
Handle_null() function in modify stage
Moderators: chulett, rschirm, roy
Handle_null() function in modify stage
Kalpana Marupudi
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom