9/4 Class Flashcards
1
Q
data warehouse
A
data is only extracted and replicated in your data warehouse
2
Q
ETL process
A
extract
transform
load
feed to users
3
Q
Fact Table
A
what people want to analyze is usually in the fact table
4
Q
data in warehouse is it changed?
A
once data is in data warehouse then it is not changed
5
Q
slowly changing dimension tables
A
over time your tables will change with the additions of new data
6
Q
Design of data warehouse
A
Two starting points
database structure
user requirements
Will help us design a dimensional model for DW
7
Q
Design single fact dimensional model
A
- decide fact and fact measurements
what do customers want to analyze?
Find measurements of fact in the source database(price, quantity, price*quantity)
