Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 49278 Views
- Apex, ASD Lab, Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is core dimension?
What is the difference between filter and lookup transformation?
What are the different problems that ?Data mining? can solve?
Which component has onread method and what it is used for?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What is the difference between snowflake and star schema?
Explain about core dimension,
What are fact, dimension, and measure?
How much data hold in one universe.
Explain swot analysis?
Explain what is the limit to the number of sources and targets you can have in a mapping?
Explain what are the different types of data warehousing?
What are the key features of chameleon that separates it from other algorithms?
What are the different types of data warehouses?
What are Non-additive facts?
