Data Warehouse Data Mart Question:
Download Questions PDF

What is data mart?


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

Download Data Mart Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is data validation strategies for data mart validation after loading process?What is the difference between a data warehouse and a data mart?