Archives of the TeradataForum
Message Posted: Thu, 21 Dec 2000 @ 16:59:59 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|