METADATA OF DATA WAREHOUSE
Metadata in a data
warehouse is similar to the data dictionary in the context of a database.
It stores data about data in the data warehouse.
Types of Metadata
Metadata in a data
warehouse fall into three major categories:
-Operational
Metadata
-Extraction and
Transformation Metadata
-End-User Metadata
Operational Metadata: As we know, data for the data warehouse comes from several
operational systems of the enterprise. These source systems contain different
data structures. The data elements selected for the data warehouse have various
field lengths and data types. Selecting data from different source files, and loading
it into the data warehouse, requires splitting of records, combining parts of records
from different source files, and dealing with multiple coding schemes and field
lengths. When information is delivered to the end-users, it is essential to be
able relate back to the original source data sets. Operational metadata contain
all of this information about the operational data sources that allow us to
trace back to the original source.
Vi hjelper deg med alt for din reise på http://www.londontown.no Her finner du alt du trenger
