Hi ,
Source and Target both are Oracle.
My source column in defined as Number(3,0) and target is defined as Number(3,0). Even though they are same datatypes. I am getting following error.
"" When writing column INT32 into database column DECIMAL(3,0), truncation, loss of precision or data corruption can occur.; CC_DBSchemaRules; reportSizeMismatch; CC_DBSchemaRules.cpp; 1575) "".
I tried loading values hard coded as 1. Then also i am getting error.
I tried using AsDouble() and AsFloat().
But still same error.
Please any Help.
Thanks
Int32 to Decimal conversion.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Int32 can have up to 10 digits. Decimal(3,0) may only have a maximum of three digits. Somewhere, something is representing data as Int32. You have to find it.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Sreedhar : My job design is Reading from Sybase database lookup with oracle table and load oracle table values to target oracle table.
oracle(Number(3,0))
|
|
Sybase --------Lookup---------Oracle(Number(3,0))
Ray : i even tried
1)creating a transformer in which i hard coded a value and defined as char. and before inserting i used string to decimal conversion.
2) i tried inserting the char field into Number(3,0) field.then also i am getting the same error.
""T_Table: ?? (IIS-CONN-DAAPI-000398; Schema reconciliation detected a size mismatch for column COLUMN1. When writing column INT32 into database column DECIMAL(3,0), truncation, loss of precision or data corruption can occur.; CC_DBSchemaRules; reportSizeMismatch; CC_DBSchemaRules.cpp; 1575) ""
Thanks
oracle(Number(3,0))
|
|
Sybase --------Lookup---------Oracle(Number(3,0))
Ray : i even tried
1)creating a transformer in which i hard coded a value and defined as char. and before inserting i used string to decimal conversion.
2) i tried inserting the char field into Number(3,0) field.then also i am getting the same error.
""T_Table: ?? (IIS-CONN-DAAPI-000398; Schema reconciliation detected a size mismatch for column COLUMN1. When writing column INT32 into database column DECIMAL(3,0), truncation, loss of precision or data corruption can occur.; CC_DBSchemaRules; reportSizeMismatch; CC_DBSchemaRules.cpp; 1575) ""
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: