Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 21 Dec 2000 @ 16:48:45 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020