 |
 |
Archives of the TeradataForum
Message Posted: Thu, 21 Dec 2000 @ 16:59:59 GMT
| Subj: | | Re: Import via ODBC |
| |
| From: | | John K. Wight |
Jiri,
I believe that you will find the OLE-DB Access module just made for your problem. However, what you will need is an NT server on
which to run the OLE Module and the NT Client FastLoad, Multiload or TPUMP (all supported by OLE-DB). You will have to configure
WinCLI as well when you install the Teradata Client software (now TUF 6.0), but that is pretty straight forward. You will find it
considerably faster that ODBC and you DO NOT need a landing zone.
Also, OLE-DB will automatically establish your landing table when you create a process. However, you can (and we do) use our own
scripts that we cut and past for the SELECT from the originating data source. Although it does not automatically generate a shell for
MultiLoad, you can (and we do) use it with MultiLoad at a customer on the west coast. Give it a try - I think (hope) you will be
pleasantly surprised! Ask your 'friendly neighborhood NCR rep' to get it on a trial basis to prove it to yourselves before you buy.
You will need an NT server for this. If you are moving a goodly amount of data with OLE, suggest you configure a dual processor
server with at least a gig or two of memory. When we went from a single processor system to a dual (550Mhz or better) with 2 gig of
memory, we saw significant improvements with larger data sets and running 2-3 jobs in parallel.
Hope this helps you.
JK
John K. Wight
Senior Solutions Consultant - Teradata Solutions Group
NCR Corp. - Arizona Territories
| |
