What is the difference between a data warehouse and a data mart?
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
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What do you mean by static and local variable?
What is core dimension?
What are loops in Datawarehousing?
Fact table is in normalized or de-normalized form?
What are the advantages of query studio compared to report studio?
Explain what are the various reporting tools in the market?
What are the types of SCD?
What are the different types of data warehousing?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Explain what are the advantages data mining over traditional approaches?
How to generate the cubes in framework manager?
What is the difference between view materialized view and view?
What are session timeout and application timeout? Where we have to do this process?