I guess your question is related to Slowly Changing Dimensions(SCDs)!!
If you take an ex that there is an object called X,the price of X in 2005 is 10,in 2006 is 20,in 2007 is 30 and now it is 40,so along with time, the price is changing, so whenever if we want to capture all these changes,we go for SCDs.
There are 3 types of SCDs:
1)Current Information:we just update the current price
2)History:all the previous prices and the current price
3)Partial History:just the price in 2007 and 2008 i.e., previous and the present |
