What is the difference between a data warehouse and a data mart?
Answer Posted / prasanta
Data Warehouse is used on an enterprise level, while Data
Marts is used on a business division/department level. A
data mart only contains the required subject specific data
for local analysis.
Is This Answer Correct ? | 30 Yes | 1 No |
Post New Answer View All Answers
Explain hybrid slowly changing dimension?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain the definition of normalized and denormalized view?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is type 2 version dimension?
What is the difference between power center & power mart?
How can we load the time dimension?
What is surrogate key? Explain with examples.
What are partition points?
How to load the time dimension?
I know of using applysimple, but there are other ways too?
What is vdl (view definition language) explain?
How did you plan your Data ware house project?
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?
Explain the definition of normalized and denormalized view and what are the differences between them?