Float to Float or Float to Integer

[imfarhan]

Dear All,
I simply use

ODBCConnector --> Transform --> DS

One of the field from source table has got type FLOAT
I keep my target table or DS as similar to srouce but i'm getting the error

SoureTbl.Field1 = float
TargetTbl.Field1 = float

Code: Select all

When reading database column INT32 into column SFLOAT, truncation, loss of precision or data corruption can occur. (CC_DBSchemaRules::reportSizeMismatch, file CC_DBSchemaRules.cpp, line 1,692)

I've also tried to use the function on stage-variable like DFloatToDecimal by changing the type on target but got different error. but I think it should be straight forware , when I take off this field but jobs run ok.

Appreciate your help!
Regards
Farhan

[imfarhan]

Done!

Weired as I said earlier the source was 'Float' and I keep the Target table|field siilar to 'Float' it generate error.

Then I change to 'double' both side source and target , ODBC_tbl and DB2|UDB respectively it works fine

Thanks to all!

Regards
Farhan

[chulett]

Glad we could help!