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
What is edw?
Is there any default username & pwd for bo designer & supervisor?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Explain the differences between normalizer and normalizer transformation?
Explain difference between data ware house & data mart?
Compare and contrast aggregates & indexes
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain er diagram?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
In microstrategy, how can we direct the sql generated to use a specifc table?
Explain what are slowly changing dimensions?
what are the major three types of modeling used?
Explain how to export mappings to the production environment?
How to create context?
How to calculate fact table granularity?