Archives of the TeradataForum
Message Posted: Thu, 21 Dec 2000 @ 16:48:45 GMT
| Subj: || || Re: Import via ODBC |
| From: || || John K. Wight |
If anyone is currently using SQL Server 7.0 and the DTS functionality to move data between a data source (e.g. Oracle, SQL Server 7.0,
etc.) and Teradata, you might want to try the OLE-DB Access module to move the data. At a customer of ours on the west coast, it is 10-15
times faster - specially with larger data sets. Don't test it with 10-20 row tables - but try 1-3 million row tables. We dramatically
reduced the data refresh time when replacing DTS with the OLE-DB Access module on both SQL Server and Oracle.
The main reason is that DTS just does an insert one row at a time whilst the OLE access module pumps data directly into the Client
FastLoad utility on the NT system. Between the NT server and Teradata, the limiting factor now becomes the speed of the LAN and the traffic
on which it supports. One could put the NT OLE server on a private high speed LAN to Teradata to help performance but be careful as the
incoming traffic from the source will now be the limiting factor. The big plus, is that you don't have to have DASD to land data before you
load it. You still have to move it across the network somehow (e.g. FTP, etc.).
John K. Wight
Senior Solutions Consultant - Teradata Solutions Group
NCR Corp. - Arizona Territories