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...
why do you want to put the location into the customer? dim location seems good to me.
However if you wanted to create dimension with the customer and location, you can create a mini dimension calling it customer location storing the primary key of customer and primary key of the location with its own dimension surrogate key being stored in the fact