Archives of the TeradataForum
Message Posted: Thu, 13 Nov 2003 @ 18:37:09 GMT
Subj: | | Re: OLE DB LOAD Version 2.2 |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, November 13, 2003 12:54 -->
I'm in a project currently using ole-load 2.2 very heavily. I have started a new standard where Titles are no longer used in Teradata
tables. I have found they get in the way of many Business Intelligence systems and don't really serve a purpose except for BTEQ.
On those tables that did use a title I have created a simple one-to-one view and used the view with OLE-Load to get around that
issue.
We have 200+ OLE-Load generated FastLoad scripts running from 5 different data sources and they all work daily. All the FastLoads are
managed with a Windows utility called Data Warehouse Toolkit (DWT).
Hope this helps....
|