Last digit gets truncated while loading into Oracle ODBC Stg
Posted: Fri Mar 30, 2007 3:39 pm
Hi,
Our current data warehouse Datastage applications are using MS SQL Server 2000 as backend database and we are in the process of migrating
to Oracle 10g. We found an issue while System Testing.
We have jobs that are reading from Complex flat file and loading it into ORACLE ODBC stage.
For a particular AMOUNT field (SQL Type DECIMAL , Length 11, Scale 2
and Display 13) source data value is 123456789.12 and while loading data
into Oracle Database using ODBC stage the last digit is getting truncated
and data is getting inserted with value 123456789.1
When we replace Target ODBC stage with DRDBMS stages (DBMS Type
ORACLE/ODBC) or Oracle OCI stage, it inserts 123456789.12 properly.
Are there any datastage functions or options available to avoid this data
truncation in Target ODBC stage?
For us to replace Target ODBC with Oracle OCI is like redoing all of our
jobs since we found this issue while System testing.
Thanks
Our current data warehouse Datastage applications are using MS SQL Server 2000 as backend database and we are in the process of migrating
to Oracle 10g. We found an issue while System Testing.
We have jobs that are reading from Complex flat file and loading it into ORACLE ODBC stage.
For a particular AMOUNT field (SQL Type DECIMAL , Length 11, Scale 2
and Display 13) source data value is 123456789.12 and while loading data
into Oracle Database using ODBC stage the last digit is getting truncated
and data is getting inserted with value 123456789.1
When we replace Target ODBC stage with DRDBMS stages (DBMS Type
ORACLE/ODBC) or Oracle OCI stage, it inserts 123456789.12 properly.
Are there any datastage functions or options available to avoid this data
truncation in Target ODBC stage?
For us to replace Target ODBC with Oracle OCI is like redoing all of our
jobs since we found this issue while System testing.
Thanks