Type Conversion Error........

[pavans]

Hi

I am getting a following error.

Un-handled conversion error on field "FOB_TYPE_C " from source type "string[40]" to destination type "decimal[10,0]":
source value="WS "; the result is non-nullable and there is no handle_null to specify a default value.

The datatype for FOB_TYPE_C is Char(40) in source table (oracle).
In Target it goes to PO_TYPE_C Number (10).

I tried using StringToDecimal(Trim(FOB_TYPE_C)) but didnt work.
Let me know your inputs.

Thanks

[chulett]

Curious... how do you propose to convert string values like your "WS" into a decimal?

[pavans]

Curious... how do you propose to convert string values like your "WS" into a decimal? ...

---------------------------
Even i was surprised to see that.
Som else has done the coding and job aborted due to this and i was looking into it for the first time. I didnt realize this.

----------------------------------------------------------


Do we have a way to handle this.
Let me know your inputs.

[chulett]

As noted in your error message:

the result is non-nullable and there is no handle_null to specify a default value.

[pavans]

As noted in your error message:

the result is non-nullable and there is no handle_null to specify a default value.

You mean:

StringToDecimal(FOB_TYPE_C);
i tried but it didnt work.
Am i missing anything here.

[ray.wurlod]

Yes, you are missing a specification of what to do when the data include a NULL.

[John Smith]

You have a data quality issue here, the source data contains row(s) with the value "WS " which you are attempting to convert to a decimal. either you provide rules to deal with this e.g what is the equivalent of WS in decimal ? or you filter out these records.