Are "INTEREST RATES" fact or dimension attributes?

View previous topic View next topic Go down

Are "INTEREST RATES" fact or dimension attributes?

Post  chrisg2 on Tue Apr 26, 2011 1:50 pm

I am designing a financial data warehouse where there are various types of interest rates which need to be modeled in the DW.
Some examples include: interest rate, average interest rate, Original interest rate, interest rate adjustment, etc.
What is the best and recommended approach in modeling such attributes? Model them as Facts in the fact table or as dimension in the Account dimension?

chrisg2

Posts : 6
Join date : 2011-04-18

View user profile

Back to top Go down

Re: Are "INTEREST RATES" fact or dimension attributes?

Post  ngalemmo on Tue Apr 26, 2011 5:16 pm

The answer would be yes to both... it all depends on what process you are modelling.

The safe thing would be to put them in the fact table. This way, depending on who asks you can say it is a measure or a degenerate dimension.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Are "INTEREST RATES" fact or dimension attributes?

Post  chrisg2 on Tue Apr 26, 2011 6:46 pm

Yes, That is what I did. Just needed a second opinion. I modeled them in the fact table as well.
One reason that made me doubt my approach was that there are those who believe that only rapidly changing facts go into a fact table.
thank you for your views.



chrisg2

Posts : 6
Join date : 2011-04-18

View user profile

Back to top Go down

Re: Are "INTEREST RATES" fact or dimension attributes?

Post  BoxesAndLines on Wed Apr 27, 2011 11:20 am

I put interest rates in fact tables as well. What I do put in dimensions are interest rate bands.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Are "INTEREST RATES" fact or dimension attributes?

Post  sgrover3 on Thu May 05, 2011 10:56 am

Is Interest Rate an additive measure? If not, then is it a good idea to add it as-is?

sgrover3

Posts : 8
Join date : 2011-04-14

View user profile

Back to top Go down

Re: Are "INTEREST RATES" fact or dimension attributes?

Post  ngalemmo on Thu May 05, 2011 12:01 pm

sgrover3 wrote:Is Interest Rate an additive measure? If not, then is it a good idea to add it as-is?

Yes, which is why I made the comment that you can call it a degenerate dimension if someone had a problem with calling it a measure.

The key question is: Would an Interest Rate dimension table make senese? Frankly, I cannot think of a situation where it would. The characteristics behind why an interest rate is what it is can be handled by other dimensions, such as Rate Basis, Contract or whatever. The rate itself stands on its own.

Is it a measure? Is it a dimension? That depends on your query and your point of view. The beauty of putting it in the fact table is it can be both.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Are "INTEREST RATES" fact or dimension attributes?

Post  Sponsored content


Sponsored content


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