I've read several articles about SCD, most of them exmplaining the standard SCD type 2 rules, like a customer adress change.
My problem is about PurchaseOrders changes :
I have a fact table "Internet Sales", with a Total property for each sale
Imagine that this Total property can change (ie. : missing product cannot be delivered) --> the order is recalculated, and its total changes. Of course, I need to keep both informations for the order, because if I do a request for the sum of the order
totals for example, I won't get the same results if the request is done with data as they where BEFORE or AFTER the Total change. .... hope that's clear.
I wanted to add a "start", "end" and 'current" columns on my fact table, but I read that it's not the good way to do.
Can you help me with that ?
PS : I didn't consider the option of setting the order total in a dimension.... hope that's not the good way to do !
View Complete Post