Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Nov 2003 @ 18:37:09 GMT


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


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023