Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Oct 2003 @ 13:52:56 GMT


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


Subj:   Re: References
 
From:   Dieter Noeth

Chris Coffing wrote:

  We take all of the DDL for every object in the warehouse and place it into a single table...  


Why? Column createtext in dbc.tvm already includes all DDL except for Tables and SPs.


  From there we can run against that table of DDL to determine what references what within the entire warehouse.  


  We run a Delta-Process to maintain this DDL table so we do not have to run the collection application on the entire warehouse everyday. The first run took about 40 minutes and every run thereafter takes less than 1 minute.  


  Why do things one at a time when you can have the entire warehouse reference information at your fingertips... We can then use this information in our Metadata website so it is easily navigated.  


Did you ever try Metadata Services? It's a part of Teradata and provides all those information.


  This is great for cleaning up the warehouse. It is the bridge to understanding what breaks when your drop an object. We now know what we will affect. I have personally reclaimed Terabytes of PermSpace using this method and that means money back to the company...  


How does the knowledge about referencing objects helps you to define which table to drop?


Dieter



     
  <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