Connecting dimension tables in a multi-fact star schema database warehouse?
1
vote
1
answer
2131
views
I am new to data warehouse modelling so please bear with me.
In database warehouse modelling, the star schema is typically a fact table with multiple dimensions connected directly to it. However, what if there are two or more fact tables in the schema and some of the dimensions are related? Please see below as an example:
Is it **allow** to draw a line to relate the dimension tables in star schema database warehouse modelling? For example, assume

dim_a
is hotel_rooms
and dim_d
is customers
, can I draw the line between the two table in the star schema since a hotel room has many customers staying?
In all the examples I searched online, the star schema is always connected to dimension tables and these tables are not drawn with a line to connect it.
Asked by user3118602
(147 rep)
May 6, 2021, 05:25 PM
Last activity: May 11, 2021, 10:03 AM
Last activity: May 11, 2021, 10:03 AM