Data Conversion warning

yarlly · Post by **yarlly** » Mon Jul 07, 2008 4:00 pm

Hi all,

I am trying to convert the source data type from Varchar to decimal and am using the Modify stage. I am getting this warning

When checking operator: When binding output interface field "column_nmae" to field "column_name": Implicit conversion from source type "ustring[max=10]" to result type "decimal[1,0]": Converting ustring to decimal.

Can you please suggest me how can i Handle this

Thanks
yar

chulett · Post by **chulett** » Mon Jul 07, 2008 4:16 pm

Doesn't seem like you have the decimal portion set up correctly: result type "decimal[1,0]" won't hold the contents of a 10 character string, hence the message.

yarlly · Post by **yarlly** » Mon Jul 07, 2008 4:45 pm

Hi Chulett,

Thanks for the reply, But I am Converting from varchar to decimal in the "Modify Stage" I am using the following Specification in Modify Stage

Column_Name:decimal = handle_null(Column_Name,0).

Please let me know if this Specification is correct.

Thanks
yar

ray.wurlod · Post by **ray.wurlod** » Mon Jul 07, 2008 5:41 pm

If the input column is a string, then there is no implicit conversion to decimal. You need decimal_from_string() function.