locked
fact and dimension tables RRS feed

  • Question

  • 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