Using a Dimension Table to Track Changes?
2 posters
Page 1 of 1
Using a Dimension Table to Track Changes?
I have the need to track changes on certain pricing/lock aspects of a loan. Our lock desk is allowed by the source system to change things like Lock Expiration Date, Loan Program Name, Loan Sell Price, Loan Buy Price. While the source system has an audit log to reflect these changes, the audit log is not query-able outside of the application or reportable inside the application. Accordingly, I would like to use a Dimension table to track these changes.
Is is OK to use a Dimension table in this standalone fashion or is there some other pattern I should be considering? My suspicion is that we are losing money on lock extensions and program changes but I can't prove it without knowing the history of the loan.
Thanks.
Is is OK to use a Dimension table in this standalone fashion or is there some other pattern I should be considering? My suspicion is that we are losing money on lock extensions and program changes but I can't prove it without knowing the history of the loan.
Thanks.
EyeBikeRide- Posts : 1
Join date : 2016-03-10
Re: Using a Dimension Table to Track Changes?
It's not clear what you mean by 'track changes'. Type 2 dimensions will naturally track changes to attribute values in the dimension. So, if all you are worried about is dimensional attributes, that should do. But, if what you mean is to maintain a record of change events, with information such as what changed, when, and by who, that is what fact tables are for... to record business events or states. A change event log would be a transactional fact table.
Similar topics
» How to track the change of a specific field in a dimension table?
» Fact table to track history on 4 dimensions?
» Track and control of dimension and fact tables
» Pros and cons of consolidated dimension table Vs. many dimension table ?
» Need to merge fact tables
» Fact table to track history on 4 dimensions?
» Track and control of dimension and fact tables
» Pros and cons of consolidated dimension table Vs. many dimension table ?
» Need to merge fact tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum