Advice of type of schema

Your diagram is a galaxy.

Essentially, a Galaxy schema can be defined as a collection of star schemas interlinked and completely normalized, to avoid redundancy and inaccuracy of data. It can also be a meaningful association of a Snowflake schema with a Star schema, etc, where the fact tables of both schemas can be linked by common dimensions.

Your Dim1 table makes your Galaxy a combination of 2 snowflake schemas

3 Likes