Sample Header Ad - 728x90

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: enter image description here 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