I have a customer table that I load. All customers are held in one table. My Sales table has two links to customers
In the customer table there is an identifier to show Purchase or Shipped or Both
What is best practice for modelling?
Would you create database views as this is possible?
If not would you use a direct query to seperate the two differnet types of customers?
It just seems plain dumb to double load the data.
Oh and the two different dimenions in the model have in the past had different column names but I am not convinced this is needed.
So the CustomerName in the Purchaser table becomes PurchaserName
And the CustomerName in the Shipped table becomes ShippedName