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

Current vs history view of datamarts

2 posters

Go down

Current vs history view of datamarts Empty Current vs history view of datamarts

Post  rajeshwarr59 Wed Dec 23, 2015 8:22 pm

Hello,

I am pretty new to data warehousing. I have been going through the Kimball forums and noticed a few posts about current view vs. history view and curious as to what's the difference between these two. I feel like I kind of get this, but getting a mixed up when I start going into details. Could someone help explain me the difference between these two concepts with an example since it helps me kind of understand clearly?

Thanks in advance.

rajeshwarr59

Posts : 21
Join date : 2015-06-26

Back to top Go down

Current vs history view of datamarts Empty Re: Current vs history view of datamarts

Post  nick_white Wed Dec 30, 2015 1:29 pm

Assuming that you are using slowly changing dimensions (and without going into the complexities of the different SCD types) then you create a new dimension record every time the corresponding source record changes - you then associate to your fact records the dimension records that hold the state of your source data when the fact occurred. This allows you to query the position when a fact occurred (the history view) and the current position e.g.

Show me the total sales last year for customers that were in debt at the time of the sale (history view)
Show me the total sales last year for customers that are currently in debt (current view)

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

Current vs history view of datamarts Empty Re: Current vs history view of datamarts

Post  rajeshwarr59 Tue Jan 05, 2016 9:53 pm

Thank you.

rajeshwarr59

Posts : 21
Join date : 2015-06-26

Back to top Go down

Current vs history view of datamarts Empty Re: Current vs history view of datamarts

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