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

Answer Posted / jaya

datamart is something which consists of only one type of
data whereas datwarehouse consists of data of different
type.For example all the organisation data say data related
to finance department,HR,Banking dept are stored in
datawarehouse whereas in datamart say only finance data
will stored.So datawarehouse is a collection of different
datamarts.

Is This Answer Correct ?    19 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate iqd file from framework manager?

523


Is union transormation is active transformation?

588


Define data warehouse?

554


What we will do with the universe for faster process?

572


What is called data cleaning?

616






What is Sequence clustering algorithm?

1545


what are the major three types of modeling used?

623


How can you set the session management?

575


Explain what is partitioning? What are the types of partitioning?

513


Explain difference between view and materialized view?

507


why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1540


What is difference between query studio and report studio?

530


Explain why fact table is in normal form?

538


What is normalization, first normal form, second normal form, third normal form?

535


what type of raid setup would you put your tx logs?

528