Archives of the TeradataForum

Message Posted: Wed, 22 Oct 2003 @ 12:48:57 GMT

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

Glen

Thanks for that observation... I got smacked earlier in my response to this thread...

WinDDI is a great tool but it does limit some return of information...

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

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.

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

Chris Coffing
Senior Vice President
Coffing Data Warehousing
www.coffingdw.com

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