What is the difference between a data warehouse and a data mart?

Answer Posted / guest

Dataware house: It is a collection of data marts.
Represents historical data.

Data mart: It is a sub set of data ware housing.
It can provide the data to analyze query reporting
& analysis.

Is This Answer Correct ?    69 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of SCD?

621


What is a junk dimension? What is the difference between junk dimension and degenerated dimension?

483


What is the difference between metadata and data dictionary?

572


What is latest version of power center / power mart?

546


Where the data cube technology is used?

539






Why should we use data ware housing and how can you extract data for analysis with example?

548


After the generation of a report to whom we have to deploy or what we do after the completion of a report?

499


What is the main difference between schema in rdbms and schemas in datawarehouse?

533


How much data hold in one universe.

544


What are the advantages and disadvantages of reporting directly against the database?

535


How to import vsam files from source to target. Do we need a special plugin?

503


Is there any difference in testing database and data ware housing?

2264


Explain bus schema?

543


Explain me what are conformed dimensions?

535


How do we design a universe?

512