Payment Fact

Hi,

I have payment fact table and I have to insert few records which I didn't get 2 years back so it is a kind of history records insertion and second thing is I may have given 100$ payment to customer 3 years back but that was incorrect, customer was only paid 80$. So I have to do history insertion as well as correction.

Anybody has any idea what is the best practice. Should I delete fact row and insert new one for updation's sake or I first insert -100 $ and then insert +80$.

Thanks
Vishy

Depends on what the business wants. If they want exposure to the change, then inserting a reversal and a new payment would be the way to go.