Archives of the TeradataForum
Message Posted: Fri, 03 Dec 2004 @ 17:22:32 GMT
| Subj: || || OLE-DB TOOL |
| From: || || McBride, Michael |
I am trying to migrate a small (43,000 rows) oracle 8i table onto Teradata. My problem is that one of the columns is defined as DECIMAL(20,0).
OLETOOL creates a table with DECIMAL(18,0) and I lose 21,000 rows to the error table due to numeric overflow. I tried making the destination a
float, but when I make the Fastload define as a float, the column is populated with a zero value (all rows).
Is there any way to convert this value through the OLETOOL (TTU 7.1)?
Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner