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.