This discussion is archived
1 Reply Latest reply: Nov 7, 2012 12:05 PM by ram chaitanya RSS

composite key

932524 Newbie
Currently Being Moderated
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

Legend

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