Wednesday 27 June 2012

SCD Type 1, SCD Type 2, SCD Type 3,Slowly Changing Dimension Types,Advantages & Disadvantages


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.

Please go through our latest post TOP6 BIG DATA TRENDS IN THE NEAR FUTURE

10 comments:

  1. Given the disadvantages of 1,2 and 3 is that we use type 4: separate table for all historical attributes.

    ReplyDelete
  2. The information provided here is very good.

    ReplyDelete
  3. SCD type 6 can also be mentioned here which is a hybrid version of 1,2,3

    ReplyDelete
  4. Excellent piece of information.. properly structured and systematic

    ReplyDelete
  5. crystal clear explanation of SCD types. Thank U so much Dude

    ReplyDelete
  6. superb information

    ReplyDelete
  7. Thank you.Its very clear and simply told.

    ReplyDelete
  8. thank you very much now got complete information about scd

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis