I have two tables, A & B, which have dimensional information but neither of them have facts or need to be counted in any way.....but each row in one table A can have multiple row in the other B...what should be the cardinality from A to B?
Cardinality is used to distinguish facts from dimensions. In a snowflake pattern you will encounter your scenario. In practice it will make little difference whether you use 1:1 or n:1 because no measures are involved. I'd still use n:1 though to 'document' in the model that 'many to one' is the case
Hi,
in that case...
A is 1
B is Many (n)
this is one to many relationship
1:1 1:n
A----------------B