 |
 |
Archives of the TeradataForum
Message Posted: Mon, 08 Jan 2001 @ 22:56:25 GMT
| Subj: | | Re: Technical Data Modelling |
| |
| From: | | Linda Borushko |
I am having good luck with the Teradata OLE Load utility. It uses OLE DB to connect to Oracle and ODBC to connect to Teradata.
It has a graphical interface that lets you choose a table from the Oracle DB then pick the columns you want to copy. It generates
the Fastload script. You can copy this to an editor and make modifications to it. It runs on NT or Win 2000. I am running it
currently on NT workstation. The performance is decent, especially so when compared to other tools. I just loaded a table of
840,000 rows in 20 minutes. The larger the table, the better it performs.
Linda Borushko
Bull Information Systems
| |
