Forum Discussion
frithjof_v
Community Champion
Community ChampionData modeling - star schema vs. very simple flat table
Hi, I am trying to get a deeper knowledge about the difference between using a star schema and a very simple flat table (potentially containing millions of transaction rows). In general, I kn...
Greg_DecklerCommunity Champion
Community Championfrithjof_v Keep it simple. Only introduce additional complexity if necessary. Star schema is mostly smoke and mirrors behind the scenes anyway. If your dimensions are only a single column, I cannot possibly see the use in them.