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

Answers were Sorted based on User's Feedback



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

Answer / guest

Dataware house: It is a collection of data marts.
Represents historical data.

Data mart: It is a sub set of data ware housing.
It can provide the data to analyze query reporting
& analysis.

Is This Answer Correct ?    69 Yes 18 No

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

Answer / thakkalpelly anil

a data warehouse is a relational database which is
specially designed for analysis purpose rather then for
transactional purpose.


a datmart is subject oriented database which gives the data
about each and every individual department in an
organisation.

Is This Answer Correct ?    47 Yes 9 No

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

Answer / mallika

Data Mart is subject oriented likes sales finance,etc..It
gets data from few no.of sources.It is maintained
departmental wise.

data warehouse consists of all subjects.Its an integrated
structure.it gets data from more number of sources.It is
maintained Centrally.Group of datamarts make a datawarehouse

Is This Answer Correct ?    39 Yes 5 No

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

Answer / prasanta

Data Warehouse is used on an enterprise level, while Data
Marts is used on a business division/department level. A
data mart only contains the required subject specific data
for local analysis.

Is This Answer Correct ?    30 Yes 1 No

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

Answer / jaya

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.

Is This Answer Correct ?    19 Yes 5 No

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

Answer / harshad

More Spcific

DW Will be your target for historical data and will be use
for Analysis.

Data Mart would be your Source for DW and will be subject
oriented.

Is This Answer Correct ?    22 Yes 12 No

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

Answer / anonymous

data mart-A Data Mart is a specific, subject oriented,
repository of data designed to answer specific questions
for a specific set of users. So an organization could have
multiple data marts serving the needs of marketing, sales,
operations, collections, etc. A data mart usually is
organized as one dimensional model as a star-schema (OLAP
cube) made of a fact table and multiple dimension tables.


data warehouse-In contrast, a Data Warehouse (DW) is a
single organizational repository of enterprise wide data
across many or all subject areas. The Data Warehouse is the
authoritative repository of all the fact and dimension data
(that is also available in the data marts) at an atomic
level.

Is This Answer Correct ?    14 Yes 4 No

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

Answer / naveen goyal

In Data warehouse, staging area is used for mapping and
integration of data collected from different sources, but in
data marts staging area is eliminated because data directly
transfers from various source systems to data marts.

Is This Answer Correct ?    12 Yes 6 No

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

Answer / sree

data mart is a scaled version of datawarehouse which
addresses to only a particular subject
datawarehouse is a database which allows to view the data
in different dimensions or perspectives

Is This Answer Correct ?    9 Yes 4 No

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

Answer / seetha

data mart is a subset of datawarehouse

data warehouse is a collection of hetrogeneous data

Is This Answer Correct ?    3 Yes 0 No

Post New Answer



More Data Warehouse General Interview Questions

Explain the different types of data warehousing?

0 Answers  


Explain degenerate dimension table?

0 Answers  


what are relationships?

0 Answers   InfoAxon Technologies,


Explain functional dependency?

0 Answers  


how to calculate sum(sal) with out using aggregator satge

3 Answers   HSBC,






Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

0 Answers  


What is Operational Data Store?

0 Answers   Informatica,


What is the goal of optimizer?

0 Answers  


What are the different types of join operations?

0 Answers  


What is an er diagram?

0 Answers  


a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

0 Answers  


What is called data cleaning?

0 Answers  






Categories