Archives of the TeradataForum

Message Posted: Tue, 19 Jan 2016 @ 09:20:03 GMT

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

What we do is run a daily process to populate a table to hold the view column names\types from the output of "HELP COLUMN dbname.tablename.*".

If views are modified within a day of this daily process running then the dbname.tablename is added to the list that has to be processed for that day.

This also helps in finding broken views since help column will not work if the view is not working.

Kiki Sanchez
Data Warehouse Group
Technology Division
United Airlines

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