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
What are the key columns in Fact and dimension tables?
What are data modeling and data mining? Where it will be used?
Explain the definition of normalized and denormalized view?
Explain what are the various reporting tools in the market?
What is data stream and data adaopter. Is it same are different? Explain?
How to create different types of templates?
How to stop a batch?
Explain what are components of report studio?
Whether dimension table can have numeric value?
What is the goal of optimizer?
Explain a mapping, session, worklet, workflow, mapplet?
What is data analysis?
What are steps we have to follow in designing the userfriendly universe?
I know of using applysimple, but there are other ways too?
What is surrogate key? Where we use it explain with example?