Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 48185 Views
- Apex, ASD Lab, Bank Of America, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhinav
data warehouse
1. DW is a collection of information for all enterprise wide.
2. it usually contain the historical data.
3.information for analysis diff. department.but can manipulate/alter the data after authorization permission.
4.store the data for corporate view.
data mart
1. it is a part of the DW.
2. its gives the total information of the particular department.
3. it allow the user to update the data for transactional use.
4. it's mostly used by the department view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nagesh dusi
datawarehouse is the collection of different subject related
information in the organization like
finance,hr,sales,purchases.datawarehouse is for analysis
purpose.we can read the data only,once the data is stored we
can not change(until the client athorization).Data warehouse
will store the historical data for analysis purpose and
Reporting purpose.To construct the data ware house it will
take 1 to 2 years.
In data mart subject related information is stored.data mart
is the part of the dataware house.it explain the information
about the particular subject. we can make changes with
insert,update and delete options.Most of the companies will
prefer Data Mart only for there organizations.Data Mart is
used to Record the current transactional record purpose. To
construct the Data Mart it will take 6 months to 8
months.organizations firstly prefer to construct there
typical area of the business first on this data mart and
based on the requirement of the organization they will
implement remaining data marts
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / mohit
In Data warehouse -- data received from staging area
In data mart -- star join (facts and dimension )
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / geeta yadav
Data warehouse is a collection of multiple subjects and many
data sources.
Data Mart is a single object and few data sources.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / neha
The collection of the datamarts is non as dataware house.
The section or part of the dataware house is called data
marts.These data marts may be independent or dependent or
both.
| Is This Answer Correct ? | 13 Yes | 15 No |
How to join 3 database like flat file, oracle, db2 in informatrica?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What are universe requirements?
What do you mean by static and local variable?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What is the difference between constraind base load ordering and target load plan?
How to test report in reportnet?
What are the primary ways to store data in OLAP?
How can we schedule the graph in unix?
What is the purpose of cluster analysis in data warehousing?
Explain what is ods (operation data source)?
Teradata 
