Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Payment Fact

2 posters

Go down

Payment Fact Empty Payment Fact

Post  Vishy Mon Jul 23, 2012 5:14 am


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$.



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

Back to top Go down

Payment Fact Empty Re: Payment Fact

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

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

Back to top Go down

Back to top

- Similar topics

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