Forum Discussion
Star Schema Model Question
Trying to set up a model for our system and am struggling with how to best set this up. I made a simple model to illustrate. But let’s say we have 2.5 Mil InvoiceLines, 70,000 Customers, 100 Locat...
The locations deal with customers in their area. And rarely do we have customers that cross over to another one. With that being said, there is a LocationID stored in the invoice as well. I just left that out to keep this simple.
A location might want to see how many of "it's" customters did business this year etc. Regardless of weather or not the business was at a different location.
I am trying to stay away from Snow Flake here, but not sure how i would do that.