Data Warehouse Data Mart Question:

Download Job Interview Questions and Answers PDF

What is the difference between a data warehouse and a data mart?

Data Mart Interview Question
Data Mart Interview Question

Answer:

Datamart is something which consists of only one type of
data whereas datwarehouse consists of data of different
type.For example all the organisation data say data related
to finance department,HR,Banking dept are stored in
datawarehouse whereas in datamart say only finance data
will stored.So datawarehouse is a collection of different
datamarts.

A data mart is a subject oriented database which supports the business needs of individual departments within the enterprise.It is an subset of the enterprise data warehouse.It is also known as high performance query structures.

Download Data Mart Interview Questions And Answers PDF

Previous QuestionNext Question
What is data mart?What we will do with the Universe for faster process?