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

13 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. This comment has been removed by the author.

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

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

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

    ReplyDelete
  7. This concept is a good way to enhance the knowledge.thanks for sharing. please keep it up MSBI online course Bangalore

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

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

    ReplyDelete
  10. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

    ReplyDelete
  11. It is a known fact that ILLUMINATI consist of Multi Millionaires,Billionaires who have major influence regarding global affairs, and planning of a New world order. Many world leaders, Presidents, prime ministers, royalty and senior executives are members of ILLUMINATI. follow the steps to Excel in Life. you'll have numerous benefits,for the FIRST TIME IN HISTORY, we are opening our doors to those who believe. If you would like to join ILLUMINATI , to sign up Text: leovincey08@gmail.com or whatsapp +2349033667873 now if you are really serious to help your self

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis