What is the difference between a data warehouse and a data mart?
Answer Posted / 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 |
Post New Answer View All Answers
Name a few sectors which use data warehousing?
What is a view as it relates to system modeling?
Explain what are the various transformation available?
How do you create surrogate key using ab initio?
Where the applications and where ware house management system is used?
What is Star Schema?
Explain why are oltp database designs not generally a good idea for a data warehouse?
What is metadata in context of a datawarehouse?
Describe a data warehouse.
What are the different types of data warehouses?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is the function of surrogate key in data warehousing?
Explain bus schema?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
Store (and count) non-fact records?