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
How to generate iqd file from framework manager?
Is union transormation is active transformation?
Define data warehouse?
What we will do with the universe for faster process?
What is called data cleaning?
What is Sequence clustering algorithm?
what are the major three types of modeling used?
How can you set the session management?
Explain what is partitioning? What are the types of partitioning?
Explain difference between view and materialized view?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is difference between query studio and report studio?
Explain why fact table is in normal form?
What is normalization, first normal form, second normal form, third normal form?
what type of raid setup would you put your tx logs?