Data Warehouse Data Mart Interview Question:

What is data mart?

Submitted by: Administrator

Data Marts is used on a business division/department level.
A data mart only contains the required subject specific
data for local analysis.
A database, or collection of databases, designed to help
managers make strategic decisions about their business.
data marts are usually smaller and focus on a particular
subject or department. Some data marts, called dependent
data marts, are subsets of larger data warehouses. A data
mart is a simpler form of a data warehouse focused on a
single subject (or functional area) such as sales, finance,
marketing, HR etc. Data Mart represents data from single
business process.

Data mart is a subject oriented data base which support the business requirement of the indivisual business department.Data mart is a sub set of the Dataware house.Since it improves the perfomance of the Dataware house,it also known as High Performance Query Structure(HPQS).


Subject means Business of Interest like HR,Finance,Sales department etc
Submitted by: Administrator