Archives of the TeradataForum

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

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

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>>