1 Reply Latest reply: Jan 11, 2013 11:30 AM by David Allan-Oracle RSS

    Fact Table, how many columns?

    971735
      I have my dimensions built, and am currently designing my very first fact table and I've hit a small confusion. Does the fact table just need to be nothing but foreign keys pointing to the primary keys of the dimension tables? Or does it need to have a column for each column in each dimension table? Thanks for the clarification.