This discussion is archived
1 Reply Latest reply: Mar 21, 2013 9:34 AM by SunilSharma RSS

what does mean 1:N cardinality relationship in joins (physical layer)

514mmreddy Newbie
Currently Being Moderated
hello experts,

could please explain what is real functionality of 1:N relation in physical join between dim -> fact.

2. what will happen in case of vice-versa ?

3. why we need to give only 1:N cardinaliny relation ? of course all other options are disable default.

4. in case of dim -> dim also we go only 1:N what is the reason?

ex: product-->Sales (1:N)

we go type-->product (1:N ) only why?

please answer me ASAP.

thanks in advance
Lakshmi kanth


  • Correct Answers - 10 points
  • Helpful Answers - 5 points