6 Replies Latest reply: Sep 21, 2015 6:20 AM by Tresesco B RSS

    Best Data Model - Thoughts?

      So like a lot of businesses, we have millions of rows, (circa 20). At present, all of the data gets put into one Fact Table, not keyed, has 170 columns and is slow. My question is this - is it better to have one fact table with 170 columns or split it out into a star schema?