Teradata Metadata Services

Database
Enthusiast

Teradata Metadata Services

Hi All,

Could you please explain me about Teradata Metadata Services? What are its uses ?

Also , is it possible to find the dependancy of table in Teradata like to know the procedures and views where a particular table is used ?

TIA.
3 REPLIES
N/A

Re: Teradata Metadata Services

Teradata Metadata Services is a comprehensive solution to manage metadata in Teradata warehouse environment. It allows users to load, manage, locate warehouse metadata.

It is possible to track dependencies for database objects.
Enthusiast

Re: Teradata Metadata Services

Thanks for the reply.

How do we track dependencies for database objects?
Could you please explain in detail?

Thanks
Teradata Employee

Re: Teradata Metadata Services

Teradata MDS reads the Data Dictionary (DBC Database) to extract information for Tables, Views, Columns, Triggers, Stored Procedures, Macros, Indexes, etc., along with the dependencies between these objects and it persists this information in the MDS Repository. Once the information is in the repository then for any given Table you can easily identify the Views, Macros, & Stored Procedures that reference the Table as well as if there are any Triggers defined on the Table.