---
title: "Define data mart"
subject: "Data Mining"
chapter: 1
key: "semester_7/data_mining:define-data-mart"
source: https://www.bctengineer.com/q/semester_7/data_mining/define-data-mart
site: BCT Engineering
---

# Define data mart

Data Mining · Chapter 1: Introduction

- Asked in: year not given
- Video: [L7: Data Mart Introduction | Types, Advantages, Disadvantages | Data Warehouse Vs Data Mart | DWDM](https://www.youtube.com/watch?v=ShP_dJWqSKQ) — Easy Engineering Classes
- Answer checked by Claude Opus 5.5 (high effort) on 2026-10-14
- Page: https://www.bctengineer.com/q/semester_7/data_mining/define-data-mart
- Whole chapter: https://www.bctengineer.com/md/semester_7/data_mining/chapter-1

## Question

Define Data Mart with example.

## Short answer

A data mart is a focused subset of a data warehouse serving one department like sales or finance, cheaper and faster to query. It can be dependent (from warehouse) or independent (from sources). Example: a bank's Loan Marketing mart holds only customer, loan product, and campaign data for the loan team.

## Answer

A **data mart** is a small, focused subset of a data warehouse that serves the needs of one department, business line or subject area, such as sales, marketing or finance. It contains only the data relevant to that group, so it is cheaper, quicker to build and faster to query than a full enterprise warehouse. It can be **dependent** (loaded from the enterprise warehouse) or **independent** (loaded directly from sources).

**Example**: A bank's enterprise warehouse covers loans, deposits, cards and HR. The *Loan Marketing data mart* holds only customer, loan product and campaign data, and is used by the loan marketing team.

## Check yourself

The answer's key points as multiple-choice questions, with the correct option and why.

1. A data mart is best described as?
   A. A small focused subset serving one department or subject
   B. A full enterprise warehouse
   C. A transaction database
   D. A metadata store
   Answer: A. It is cheaper and faster than the full warehouse. (Key point: Data mart definition)

2. What is a dependent data mart?
   A. Without data
   B. Loaded from the enterprise warehouse
   C. A backup
   D. Loaded directly from sources
   Answer: B. Independent ones load directly from sources. (Key point: Dependent mart)

3. What does the Loan Marketing mart contain?
   A. Card transactions
   B. Only customer, loan product and campaign data
   C. All bank data
   D. HR data
   Answer: B. It holds only data relevant to loan marketing. (Key point: Example)

## Related in Data Mining

- [Data warehouse, data mart and need](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Awarehouse-datamart-need) — Data Mining, chapter 1
- [Virtual warehouse, data mart, enterprise warehouse](https://www.bctengineer.com/question.md?key=semester_7%2Fdata_mining%3Avirtual-data-mart-enterprise-warehouse) — Data Mining, chapter 1