Forum Discussion
What is better between Star Schema x Append?
The title is self explanatory but what is the difference? do both serve the same purpose? what are the advantages and disadvantages between them.
Anonymous - I would append your two tables ensuring that you have a Location ID in your fact table. I would then create a Location dimension as a separate table. So:
Location
LocationID,Name
1,Paris
2,New York
Fact Table
LocationID,Date,Rainfall
1,1/1/2020,2
1,1/2/2020,3.5
...
You would also want a Date dimension (calendar table)
