Data Warehousing Community Forum
November 21, 2018, 02:16:21 am

Pages: [1]   Go Down
  Print  
Author Topic: Star Schema with more than one fact tables?  (Read 1861 times)
AgentLeo
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 1


View Profile
« on: September 09, 2016, 08:13:54 pm »

Hi,
I would like to ask if it is possible to have a star schema with more than one fact tables.
If we can have such a schema, how this fact table is linked with the dimensions, given that loops are not permitted?  I am using BO Universe Designer.

Thank you in advance for your help.

Logged
advertisement
SuGoSu
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 5


View Profile
« Reply #1 on: November 05, 2018, 05:43:09 pm »

If you have more than one fact table, then it's not Star Schema anymore. Its Galaxy Schema (yeah I'm not funny)

Well, the thing is, if you want to combine 2 fact tables, you should use a bridge dimension, which makes your model as a snowflake, which is not a bad thing at all. Let me draw it for you :

D   D          D     D

D   F    B     F     D

D   D          D     D

D: Dimension
F: Fact
B: Bridge


Good luck.
Logged
Pages: [1]   Go Up
  Print  
Jump to: