Star Schema for Data Modelling (Beginner)

  • I'm trying to convert scenario into database tables using Star Schema...To do that, I would need dimension tables and fact tables. I'm confused as to how many fact tables are allowed for the star schema..since in the examples that I read, only fact table is used....Are 2 or more fact tables allowed for star schema? Also, in the fact table, only the columns of interest should be shown?

  • It's easier to start with one fact table and create dimension tables for that.  It's certainly possible to have more than one fact table in a model, but if you're just starting out, you should probably get your head around that first.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply