Fast Changing Dimensions are
dimensions that keep changing rapidly. Previously we had discussed about slowly
changing dimension, which can be handled by Type1,Type2 or Type3.In case of rapidly changing dimension it cannot be managed
by any of these Types.
For RAPIDLY CHANGING DIMENSION we
need to split the actual dimension table into many Mini Dimensions. These Mini
dimensions can be one ore more and will contain the Fast Changing attributes in
the dimensions So now there will be one or more mini dimensions and primary
dimension table. Also the fact table will have two or more foreign keys, one
for the primary dimension table and another for the one or more
mini-dimensions.
Hence
we will have two dimensions now,
- One table is the actual dimension minus the fast changing attributes.
- Another is the mini dimensions having the fast changing attributes.
Can someone please provide a real life example for a fast changing dimension?
ReplyDeletechintan examples are customer age,rating, income these are rapidly changing dimension.
ReplyDeleteis the fastly changing dimension an independent table or a narmalised table from the parent dimention when it is split
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteRapidly changing large dimension can be too problematic for the type 2 approach. The dimension table could be littered with a very large number of additional rows created every time there is an incremental load.
ReplyDeleteThe type 2 apporach is still good in a star schema design.
You need to break off the rapidly changing attributes into another dimension table leaving the slowly changing attributes behind in the orignal table.
stock exchange related table ....I guess we can consider the part of fast changing dimension
ReplyDelete