1 Reply Latest reply on Nov 7, 2012 8:05 PM by ram chaitanya

    composite key

    932524
      Hi All,

      Can I create a composite key for new logical dimension in BMM layer ? for example combining three id countryid+StateID+EmployeeID for new logical dimension whose source will be county, state and employee table in physical layer. I also need to create a factless logical fact table where this composite/surrogate key should be placed in order to create a star schema.

      Thanks,

      Virat