Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 08 Jan 2001 @ 22:56:25 GMT

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

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

  <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