Data copy error- Exponential Value - Oracle 10G to 12C Exada

clmhwyfe · Post by **clmhwyfe** » Sun Oct 04, 2015 2:28 pm

Hi All,

We are using Datastage 8.7 to copy tables over from Oracle 10G to Oracle 12c Exadata platform. Looks like Datastage is rounding off a large number.

The number is defined as NUMERIC in both source and target. Am using a generic job having RCP enabled and a parameter that passes the table name.

The Source data is as below -
-7142805135277041
-7142805149865047

But the target is getting populated as
-7142805135277040
-7142805149865050

When DBA uses the copy command and copies data between the servers it works perfectly fine.

ray.wurlod · Post by **ray.wurlod** » Sun Oct 04, 2015 2:45 pm

What is the data type in DataStage?

clmhwyfe · Post by **clmhwyfe** » Sun Oct 04, 2015 2:54 pm

Hi Ray,

Since we had to copy a lot of tables, we didn't specify any column name/property.

RCP is enabled and we use a plain SELECT * FROM #TBL# and Bulk load to the target, I just have a copy stage in between the source connector and target connector.

Thanks

clmhwyfe · Post by **clmhwyfe** » Sun Oct 04, 2015 3:05 pm

Hi ,

I did a quick test by giving the column details (Declared it as a DECIMAL 38,10) and it loads the values correctly without rounding it off.

But there are almost 300 tables that needs to be copied, I would like to get suggestions as to why this can happen with such large numbers.

Thanks

clmhwyfe · Post by **clmhwyfe** » Mon Oct 05, 2015 10:24 am

Hi All,

Any thoughts as to why RCP without column definitions/properties would default large numbers ?