Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 48871 Views
- Apex, ASD Lab, Bank Of America, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best
What are the different models used in cluster analysis?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
explain about dirty dimension?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
What is the difference between datawarehouse and bi?
What are the advantages of raid 1, 1/0, and
What is Discrete and Continuous data in Data mining world?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Explain what are components of report studio?
Explain Association algorithm in Data mining?
What is dimension modeling?
Teradata 
