Questions about star-schema-datawarehouse
Read more about star-schema-datawarehouse
python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Whether sales (fact) table should be made to have the userid from customer (dim) table in dimensional modeling?
I have following relationships:
User (userid, username)
Customer (customerid, userid, customername)
Sales (salesid, customerid, saledate, saleamt)
In the DW I am loading the data as follows:
User (use...
variable
Votes: 0
Answers: 1
Should I use multiple fact tables for each grain or just aggregate from lowest grain?
Fairly new to data warehouse design and star schemas. We have designed a fact table which is storing various measures about Memberships, our grain is daily and some of the measures in this table are t...
Niall Nicholls
Votes: 0
Answers: 1