Cardinality

The cardinality of a relationship indicates how many rows of one table correspond to a row of the other: one-to-many (the normal case, dimension to facts), one-to-one or many-to-many. It must reflect the real data; many-to-many relationships should be avoided when possible.

Example

A product appears in several sales rows: one-to-many relationship.

Related concepts

The whole glossary