Siksha Sarovar

Siksha Sarovar (sikshasarovar.com) is a free educational web application that helps students in India learn programming and prepare for academic and competitive exams. The platform offers structured coding courses (C, C++, Python, Java, HTML, CSS, PHP, Power BI, AI, Machine Learning, Data Science), complete university curriculum notes for BCA/MCA students with previous year question papers, Class 10 and Class 12 CBSE/HBSE school notes, and dedicated preparation material for SSC, UPSC, Banking, Railway and other government exams. Browsing the site is completely free and requires no account. Users may optionally sign in with Google solely to save their learning progress, quiz scores and personal preferences across devices.

Privacy Policy | Terms of Service | Contact Siksha Sarovar | About Siksha Sarovar

v4.0.9 · PWA
Siksha Sarovar logo
Siksha Sarovar
Your Learning Universe

Siksha Sarovar is a free e-learning platform for coding courses, BCA university notes and competitive exam preparation. Optional Google sign-in saves your learning progress across devices.

Initializing knowledge base…
Compiling modules 0%

Metadata Repository

Lesson 9 of 32 in the free Data Warehousing and Data Mining(Elective-II) notes on Siksha Sarovar, written by Rohit Jangra.

---

8. Metadata Repository

8.1 Definition

Metadata is "Data about Data." The Metadata Repository is a central catalog that stores information about the data warehouse itself. It acts like a map or a dictionary for the warehouse.

8.2 Why is it needed?

Without metadata, the data warehouse is just a pile of numbers. Metadata tells users what the data means, where it came from, and how it was processed.

8.3 Types of Metadata

  1. Technical Metadata:
  • Used by IT/Developers.
  • Contains schema definitions, mapping rules, ETL scripts, database structure, and data types.
  • Example: "The column 'Cust_ID' is an Integer and is the Primary Key of the Customer table."
  1. Business Metadata:
  • Used by Business Users.
  • Contains definitions of business terms, ownership, and policies.
  • Example: "Profit is defined as (Revenue - Cost). It is calculated monthly."
  1. Operational Metadata:
  • Used for Maintenance.
  • Contains execution history of ETL jobs, data lineage (where data came from), and error logs.
  • Example: "The sales data load failed on 12/12/2023 at 2:00 AM due to network timeout."