Payment Fact

View previous topic View next topic Go down

Payment Fact

Post  Vishy on Mon Jul 23, 2012 5:14 am

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

Vishy

Posts : 75
Join date : 2012-02-28
Location : India

View user profile

Back to top Go down

Re: Payment Fact

Post  ngalemmo on Mon Jul 23, 2012 4:03 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum