Thursday, October 16, 2014

MetaData Repository

Metadata Respiratory

The Metadata Respiratory is an integral part of data warehouse system. The Metadata Respiratory contains the following metadata:
  • Business Metadata - This metadata has the data ownership information, business definition and changing policies.
  • Operational Metadata -This metadata includes currency of data and data lineage. Currency of data means whether data is active, archived or purged. Lineage of data means history of data migrated and transformation applied on it.
  • Data for mapping from operational environment to data warehouse -This metadata includes source databases and their contents, data extraction,data partition, cleaning, transformation rules, data refresh and purging rules.
  • The algorithms for summarization - This includes dimension algorithms, data on granularity, aggregation, summarizing etc.

No comments: