fact and dimension tables

• Question

• 

  

  0

  Sign in to vote

  Hi,

      suppose i have two dimension tables and one fact table 

  dimtables:

  product--pk1,pk2

  customer--

  fact:

  Sales

  here my doubt is that can we create two primary keys pk1,pk2 can we refer these both keys in fact table that is from one dimension table

  thanks in advance

  Friday, June 29, 2012 8:01 AM