Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Feb 2004 @ 15:10:00 GMT


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


Subj:   Re: FastLoad or MultiLoad Sample script
 
From:   Shealy, Shawn

Hi Rishi and Satya,

You can use the Teradata OLE DB Access Module product to perform loads from many types of data sources (Oracle is one) without putting the data into a flat file first. The load utility (i.e. FastLoad) gets the data from the OLE DB access module which in turn gets the data from the OLE DB provider for Oracle which in turn gets the data from Oracle. BTW, If all of this sounds slow, well it isn't. Consider this, the OLE DB access module can also be used in a load from a flat file by using the Microsoft OLE DB Provider for ODBC Drivers in conjunction with the Microsoft Text Driver. Testing has shown that a FastLoad of a LARGE table from a flat file via the OLE DB access module is typically faster than a FastLoad directly from the same flat file. The reason for this surprising result is that the Teradata OLE DB Access Module parallelizes the reading of the flat file with the loading of the data. Note: Use the "batch" argument to the OLE DB access module for best performance. Furthermore, the OleLoad program included in the Teradata OLE DB Access Module product will generate the FastLoad, MultiLoad, TPump, or BTEQ script to perform the load for you.


Hope it helps!

-shawn :-)



     
  <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: 27 Dec 2016