What is the difference between a data warehouse and a data mart?
Answer Posted / neha
The collection of the datamarts is non as dataware house.
The section or part of the dataware house is called data
marts.These data marts may be independent or dependent or
both.
| Is This Answer Correct ? | 13 Yes | 15 No |
Post New Answer View All Answers
Fact table is in normalized or de-normalized form?
What is a real-time data warehouse?
What are the differences between datamart vs. Reporting cube?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What are data modeling and data mining? Where it will be used?
What is incremintal loading?
What is the difference between Datawarehouse and OLAP?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
What are the various transformation available?
What is prompt types of prompts?use of prompts syntax of prompt?
What are the reasons to use a chameleon method in data warehousing?
Is there any default username & pwd for bo designer & supervisor?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What are the approaches used by optimizer during execution plan?
What are the design methods of data warehousing?