Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - What is Fastly Changing Dimension?

asked mar September 20, 2014 06:31 AM  

What is Fastly Changing Dimension?


1 Answers

answered By vishnoiprem   0  
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.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!