Table Cardinality

[dssd]

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?

[blom0344]

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

[Satheesh]

Hi,
in that case...
A is 1
B is Many (n)
this is one to many relationship


   1:1       1:n
A----------------B