DSXchange

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

I assume that you have just like

Read Oracle -> Load Oracle.

Can you provide with your Job design.
That should help us give some Idea of what is going wrong.

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.

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

Re-read my response. DataStage is alerting you to the fact that some integers have more than three digits, so you may end up losing data.

Did you try actually defining your column as decimal instead of numeric?