1 Reply Latest reply: Mar 21, 2013 11:34 AM by SunilSharma RSS

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

    514mmreddy
      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