Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Are "INTEREST RATES" fact or dimension attributes?

4 posters

Go down

Are "INTEREST RATES" fact or dimension attributes? Empty Are "INTEREST RATES" fact or dimension attributes?

Post  chrisg2 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

Back to top Go down

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

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

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

http://aginity.com

Back to top Go down

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

Post  chrisg2 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

Back to top Go down

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

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

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

Back to top Go down

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

Post  sgrover3 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

Back to top Go down

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

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

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

http://aginity.com

Back to top Go down

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

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum