I'm trying to create a Star Schema/Galaxy Schema in my datawarehouse and am trying to avoid creating a Snowflake Schema. I currently have 6 dim tables and 10 fact tables. Is it alright to have multiple fact tables connecting to one dimension table? E.g 4 Fact tables connecting with 1 Dim table.
Asked
Active
Viewed 809 times
0
-
Of course. The whole point of using dimensions is to reuse them in all your fact tables (as long as the dimension applies to that fact table). A snowflake schema means you link your fact to a dimension and that dimension links to another dimension. – Wouter Aug 19 '20 at 12:51
-
If we assume, that all fact tables are assigned to at least one dimension (which is a very reasonable assumption in a DWH setup) you even have *no other chance* than to share dimensions between fact tables - as you have 10 fact tables but only six dimensions... – Marmite Bomber Aug 19 '20 at 14:16
-
Thanks guys, for the info :) Though I'm not able to put a 'tick' on the comments section – Zafear Aug 20 '20 at 01:54