1 Reply Latest reply on Jan 11, 2013 5:30 PM by David Allan-Oracle

    Fact Table, how many columns?

      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.