Overpayments Fact and dimension tables

View previous topic View next topic Go down

Overpayments Fact and dimension tables

Post  tim_goodsell on Wed May 30, 2012 12:09 am

Hi

My source system has a table that contains information concerning overpayments (each record is a separate overpayment):

Each record contains

Client ID
Overpayment Date
Gross Overpaid amount
Net Overpaid amount
Tax overpaid amount
First letter sent date
Second letter sent date
Third letter sent date
Balance owing
Amount repaid

The primary key is Client ID, Overpayment date

This table is updated (Balance owing, amount repaid ) each time a payment is made to reduce the overpayment or when a letter is sent (First Letter, Second Letter, Third Letter). The table has modifed user/date fields

Should I just have one fact table containing the above information (history of the overpayment) or a dimension table (overpayment) and a fact table. I am trying to create a monthly snapshot table that indicates the state of the overpayment/repayment process at the end of each month.

Regards

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Overpayments Fact and dimension tables

Post  hkandpal on Wed May 30, 2012 7:21 am

Hi,

you can have the clinet info in the dimension table but the overpayment should be a fact table ? Will there be a case of more than 3 overpayment letters being sent and if yes will the system be intrested in capturing that.


thanks

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

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