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 explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What is a general purpose scheduling tool?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is an error log table in informatica occurs and how to maintain it in mapping?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Compare and contrast aggregates & indexes
Explain what are non-additive facts in detail?
What are the advantages of query studio compared to report studio?
What is the difference between power center & power mart?
What are different deliverables according to phases?
How can you communicate with web server (apache or iis) from coldfusion?
What is the data type of the surrogate key?
Give some difference between oltp and olap.
What is mean by aggregate aware?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in