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

Answer Posted / harshad

More Spcific

DW Will be your target for historical data and will be use
for Analysis.

Data Mart would be your Source for DW and will be subject
oriented.

Is This Answer Correct ?    22 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

572


ware house management system is used?

578


What are the steps involved in creating dimensional modeling process?

563


Who needs data warehousing?

560


What according to you might be the future of data warehousing?

529






Explain datawarehousing?

555


What is latest version of power center / power mart?

557


Explain what are non-additive facts?

565


Code the tables statement for a single-level (most common) frequency?

471


What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

484


Explain the hierarchies level data warehousing.

512


What is the function of etl when used in data warehousing?

541


How to define a cube??

550


Explain piconet?

551


Briefly state different between data ware house & data mart?

563