Impact Analysis - Teradata Meta Data Services

Impact Analysis

Teradata MDS lets you determine the impact of changes to the warehouse prior to implementation. For example, if you perform a search and examine the metadata for a view, MDS Repository Explorer displays a list of tables and columns that the view references, as shown in Figure 24.

Figure 24: The View Info screen

Using this information, you can easily determine the impact of various scenarios:

What data is maintained in this database?

What views are affected if I drop this column?

What tables are referenced by this stored procedure, macro, or view?

Where did this view come from, and what table columns does it reference?

Are there any possible broken views, macros, or stored procedures?

What was the last Teradata DDL change, and when did it take place?