 |
 |
Archives of the TeradataForum
Message Posted: Thu, 30 Nov 2006 @ 18:46:36 GMT
| Subj: | | Re: Performance Tips for SQLPLUS / Named Pipes / |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, November 30, 2006 13:42 -->
Mohommod.Khan writes:
| | Since you are extracting all your data and loading it to empty table, try extracting the oracle data onto flat files, delimited. Now load
it using FastLoad. Compare the load times. The other option would be using Ole Load or warehouse builder but they use odbc and I doubt they will
be faster than the named pipe. | |
The comment about OleLoad is misleading. I think OleLoad only uses ODBC for initial job configuration. The actual transfer of data into the
Teradata database is done using a load utility such as FastLoad. ODBC is not used in this data transfer and my experience has been that this is a
high performing way of transferring data from Oracle into Teradata.
| |
