What is the difference between a data warehouse and a data mart?
Answer Posted / guest
Dataware house: It is a collection of data marts.
Represents historical data.
Data mart: It is a sub set of data ware housing.
It can provide the data to analyze query reporting
& analysis.
Is This Answer Correct ? | 69 Yes | 18 No |
Post New Answer View All Answers
The same tier?
what are the major three types of modeling used?
What are the design methods of data warehousing?
How can we do data cleaning?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain the differences between normalizer and normalizer transformation?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
What are vaious etl tools in the market?
How can we load the time dimension?
Explain what are the advantages of query studio compared to report studio?
What is difference between query studio and report studio?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the various transformation available?
What is execution plan?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?