Using a Dimension Table to Track Changes?

View previous topic View next topic Go down

Using a Dimension Table to Track Changes?

Post  EyeBikeRide on Thu Mar 10, 2016 11:12 am

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.

EyeBikeRide

Posts : 1
Join date : 2016-03-10

View user profile

Back to top Go down

Re: Using a Dimension Table to Track Changes?

Post  ngalemmo on Thu Mar 10, 2016 4:59 pm

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