Hi all, I am loading data from Oracle to Teradata using SAS pass-through Code example: CONNECT TO ORACLE () INSERT INTO TDLIB.tblnm(fastload=yes) Select * from connection to oracle( Select * from oradb.ora_tblnm ) In Oracle data is like : 99999999999999.99 (datatyep-Number(20,4) But after loading in Teradata it gets round of to : 100000000000000.00 Tried with DATA SET OPTION- DBTYPE But though getting it like :99999999999999.9872 with decimal (20,4) And 99999999999999.98 with decimal (20,2) I want it to be loaded as 99999999999999.9900 in Teradata Need a solution for this. Thanks.
... View more