SetNull with decimal fields

saxena_richa · Post by **saxena_richa** » Wed Jun 11, 2008 2:21 pm

Hi,
I want to put Null into database for a particular decimal column if I dont get any value from source.
But when I try to use the SetNull function , I get the followin error:-

value larger than specified precision allowed for this column

Need help to understand why I get this error and also the workaround for this.

The target is oracle database and source is a flat file.
Thanks
Richa

Minhajuddin · Post by **Minhajuddin** » Thu Jun 12, 2008 1:07 am

You can try changing the datatype in the oracle stage to a varchar and pass an empty string for NULLs.