Data warehousing - difference between metadata and data dictionary

Difference between metadata and data dictionary.

Metadata describes about data. It is ‘data about data’. It has information about how and when, by whom a certain data was collected and the data format. It is essential to understand information that is stored in data warehouses and xml-based web applications.

Data dictionary is a file which consists of the basic definitions of a database. It contains the list of files that are available in the database, number of records in each file, and the information about the fields.

What is the difference between metadata and data dictionary?

Data dictionary is a repository to store all information. Meta data is data about data. Meta data is data that defines other data. Hence, the data dictionary can be metadata that describes some information about the database.
Data warehousing - various methods of loading Dimension tables.
Various methods of loading Dimension tables - The following are the methods of loading dimension tables........
Data warehousing - difference between OLAP and data warehouse
Difference between OLAP and data warehouse - The following are the differences between OLAP and data warehousing.......
Data warehousing - Describe the foreign key columns in fact table and dimension table.
Foreign key columns in fact table and dimension table - The primary keys of entity tables are the foreign keys.......
Post your comment