The
Slowly Changing Dimension problem is a common one particular to data
warehousing.There are in general three ways to solve this type of problem, and
they are categorized as follows:
- Type 1: The new record replaces the original record. No trace of the old record exists. Read more
- Type 2: A new record is added into the customer dimension table.Thereby, the customer is treated essentially as two people. Read more
- Type 3: The original record is modified to reflect the change. Read more
If you like this post, please share it on google by clicking on the
Google +1 button.
Given the disadvantages of 1,2 and 3 is that we use type 4: separate table for all historical attributes.
ReplyDeleteThe information provided here is very good.
ReplyDeleteSCD type 6 can also be mentioned here which is a hybrid version of 1,2,3
ReplyDeleteExcellent piece of information.. properly structured and systematic
ReplyDeletecrystal clear explanation of SCD types. Thank U so much Dude
ReplyDeletesuperb information
ReplyDeleteThank you.Its very clear and simply told.
ReplyDeletethank you very much now got complete information about scd
ReplyDeleteWell said in precise
ReplyDeleteShort and sweet. Thanks
ReplyDelete