Pages

▼

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
at

10 comments:

  1. Marius de With17 October 2012 at 20:12

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

    ReplyDelete
  2. Abhishek31 October 2012 at 10:39

    The information provided here is very good.

    ReplyDelete
  3. saurav_srv26 March 2013 at 02:44

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

    ReplyDelete
  4. Anonymous29 October 2013 at 13:16

    Excellent piece of information.. properly structured and systematic

    ReplyDelete
  5. Anonymous1 November 2014 at 23:36

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

    ReplyDelete
  6. Anonymous31 August 2015 at 07:53

    superb information

    ReplyDelete
  7. Unknown11 September 2018 at 09:55

    Thank you.Its very clear and simply told.

    ReplyDelete
  8. Unknown22 November 2018 at 23:14

    thank you very much now got complete information about scd

    ReplyDelete
  9. venugopal10 January 2020 at 08:50

    Well said in precise

    ReplyDelete
  10. Unknown31 December 2020 at 09:18

    Short and sweet. Thanks

    ReplyDelete