"7.4920914851712331E-2" convert to decimal(19,0)

dataservices job design
1

I have converted REV to type decimal(19,0), in source datatype is varchar(255).
I have used following function in query mapping.

cast(AQ_PT_DATA_EXTENDED_COVERAGE.PREMIUM, ‘decimal(19,0)’)

It is working fine, but in certain cases it is not working , for example when REV is equal to “7.4920914851712331E-2” , but after conversion to decimal(19,0) it become NULL.

thanks

GBS74 (BOB member since 2007-01-23)