Overpayments Fact and dimension tables
2 posters
Page 1 of 1
Overpayments Fact and dimension tables
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
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
Overpayments Fact and dimension tables
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
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
Similar topics
» Storing Date Keys in dimension tables versus fact tables
» Number of Columns in Fact Tables vs. Dimension Tables
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
» Dimension Design with intermediate tables between fact and dimension
» Number of Columns in Fact Tables vs. Dimension Tables
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
» Dimension Design with intermediate tables between fact and dimension
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum