Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Same Dimensions, multiple Fact tables, different measures, millions of rows

Hello, I've been creating/updating/enhansing reports for years, even played a bit with dimensional modeling on very simple cases ( up to 10k rows), but in terms of real dimensional modeling with lot...
Need Help
  • bcdobbs's avatar
    bcdobbs
    3 years ago

    I think you've got exactly the right idea! Give it a go. Every data model is different but for example a normal pattern I use in education has a number of fact tables will shared dimensions:

    We often use measures that require calculations from more than one table!

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
3 years ago

If the two fact tables contain different "facts" then I'd keep them separate and link them to your common (conformed) dimensions exactly ad you describe. It would though help if you described what is contained in the two fact tables. This is sometimes called a galaxy schema but I prefer to just think of it as multiple star schema. As long as the dimensions are common it'll work perfectly.