 |
 |
Archives of the TeradataForum
Message Posted: Fri, 03 Dec 2004 @ 18:14:51 GMT
| Subj: | | Re: OLE-DB TOOL |
| |
| From: | | Victor Sokovin |
| | 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). | |
18 is the current limit for numeric fields, so the only way to load such data is via the string format. It is OK if you just want to
display that data but you won't be able to do any mathematics on it (unless you are prepared to work with strings).
Regards,
Victor
| |
