Match List - I with List - II:

Choose the correct answer from the options given below:

Correct option is A

The correct match is:

• (A) Data Marts → (IV) Subset of a data warehouse, typically consisting of a single subject area
  A Data Mart is a departmental subset of a data warehouse, usually focused on a specific subject area like sales, finance, etc.

• (B) Operational Data Store (ODS) → (I) Provides a fairly recent form of customer information file and is used as interim staging area
  ODS is a temporary data store that integrates data in near-real-time and is used for current operational reporting.

• (C) Enterprise Data Warehouse → (II) Provides integration of data from many sources into a standard format
  The EDW is the central data repository that consolidates data from across the enterprise into a unified schema.

• (D) Metadata → (III) Describe the structure and some meaning about data
  Metadata is “data about data”, meaning it gives context, structure, and explanation about data — e.g., data type, source, usage.

Information Booster:

• Data Marts allow for faster queries and focused analytics since they are domain-specific.

• ODS is used when real-time or near-real-time data access is needed without affecting the core systems.

• Enterprise Data Warehouse (EDW) is vital for strategic decisions, offering a 360-degree view of the organization.

• Metadata improves data usability by providing context, rules, and lineage about the stored information.

• EDWs typically involve ETL (Extract, Transform, Load) processes to standardize and load data.

• Data Marts can be dependent (sourced from EDW) or independent (standalone).

• ODS helps bridge the gap between transaction systems and data warehouses.