What is the difference between a data warehouse and a data mart?
Answer Posted / sree
data mart is a scaled version of datawarehouse which
addresses to only a particular subject
datawarehouse is a database which allows to view the data
in different dimensions or perspectives
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
What is Analysis Services?
How can we load the time dimension?
Explain what are the vaious etl tools in the market?
Explain what is the metadata extension?
Explain how are the dimension tables designed?
Explain what are the different types of data warehousing?
Fact table is in normalized or de-normalized form?
What is the advantages data mining over traditional approaches?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
In microstrategy, how can we direct the sql generated to use a specifc table?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is batch processing?
Explain is olap databases are called decision support system true/false?
What are the stages that are required in data warehousing?
What is the use of incremental aggregation? Explain me in brief with an example?