Data Warehousing & BI Training: https://www.edureka.co/data-warehousing-and-bi
Slowly changing dimensions (SCD) determine how the historical changes in the dimension tables are handled. Implementing the SCD mechanism enables users to know to which category an item belonged to in any given date.
Topics covered in this video are:
1. SCD type 1 - Overwrite the old value.
2. SCD type 2 - Add a new Row.
3. SCD type 3 - Add a new Column.
Related Blogs:
http://www.edureka.co/blog/architecture-of-a-data-warehouse/?utm_sourceyoutube&utm_mediumreferral&utm_campaign slowly-changing-dimension
http://www.edureka.co/blog/importance-and-benefits-of-data-warehousing/?utm_sourceyoutube&utm_mediumreferral&utm_campaignslowly-changing-dimension
Watch the sample class recoding: http://www.edureka.co/datawarehousing?utm_sourceyoutube&utm_mediumreferral&utm_campaignslowly-changing-dimension
Edureka is a New Age e-learning platform that provides Instructor-Led Live, Online classes for learners who would prefer a hassle free and self paced learning environment, accessible from any part of the world. The topics related to ‘Introduction to Dataware Housing’ have been covered in our course ‘Datawarehousing‘. For more information, please write back to us at
[email protected]Call us at US: 1800 275 9730 (toll free) or India: +91-8880862004