Archives of the TeradataForum
Message Posted: Wed, 22 Oct 2003 @ 13:52:56 GMT
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
|