1 Reply Latest reply: Nov 7, 2012 2:05 PM by ram chaitanya RSS

    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