Data warehouses
3 important questions on Data warehouses
What are the possible ways to design a DW as the union of a set of separate data marts?
•over a period of time,
•by different design teams
•on different platforms
•by different design teams
•on different platforms
`What are the 9 steps for database design methodology for a DW?
1.Choosing the business process/department
2.Choosing the grainof data to be stored
3.Identifying and conforming the dimensions
4.Choosing the facts
5.Storing pre-calculations in the fact table
6.Rounding out the dimension tables
7.Choosing the duration of the database
8.Tracking slowly changing dimensions
9.Deciding the query priorities and the query modes
2.Choosing the grainof data to be stored
3.Identifying and conforming the dimensions
4.Choosing the facts
5.Storing pre-calculations in the fact table
6.Rounding out the dimension tables
7.Choosing the duration of the database
8.Tracking slowly changing dimensions
9.Deciding the query priorities and the query modes
What is called a fact constellation in a Dimensional Model?
A dimensional model containing two or more fact tables that share one or more conformed dimension tables is termed a Fact Constellation
Try our study magic for free
a PDF, study it super fast
- No sign up, email or credit card needed!
- AI makes unlimited flashcards
- Get unlimited quizzes and tests
- Ask AI anything
Create a notebook
- No sign up, email or credit card needed!
- Have and keep perfect overview
- Make flashcards, notes and mind maps
- Review, test and score!
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
