During the next few weeks I will be posting articles relating to the Meta Database. This database is used to house information relating to the following topics:
Data Dictionary – A repository of information which describes the tables, views and columns that store data, as well as the data map for how they entered these database objects.
Audit – A set of tables used to track the execution of SSIS Packages (or, theoretically, any other job or script)
Data Quality Screens – A set of tables used to track the accuracy of data.
Control – A set of control tables used to help the processing of the sql packages.
Configurations – The standard SQL Server configurations table.