Dimensional Data Modeling - Relationship

About

In a dimensional data model, you have mostly a one-to-many relationship

• between the dimension and the fact table
• between each level in a hierarchy

man-to-many relationship are modeled with a bridge table (association) with a factor.

Articles Related