Adding, Modifying, and Deleting Teradata Database Systems
The next step is to load your Teradata physical data warehouse information into the
repository. The advantages of having a Teradata MDS repository with the data dictionary
information are:
You can use Teradata MDS to see if information is in the warehouse before adding new
tables and columns, eliminating data redundancy.
You can use Teradata MDS for dependency analysis.
Identify what views, macros, or join indexes reference a specific table column.
Identify the objects that a stored procedure references.
Identify intermediate view dependencies.
You can use Teradata MDS as a maintenance tool to detect broken views, macros, triggers,
or stored procedures (i.e. views, macros, triggers, or stored procedures that reference
nonexistent tables).
You can determine what changes have been made with the Teradata MDS audit trail. Many
times users will say nothing has changed, but you find that it has.
You can compare database and table definitions,
Viewing the data dictionary information from the Teradata MDS repository is faster
and offloads accesses to the DBC tables.
You can view relationships not directly available by querying the data dictionary,
such as:
All views that reference a column
All triggers on a table or column
All stored procedures which reference a table or view
You can provide business definitions or descriptions for warehouse information.