Slowly Changing Dimension Type 1 ( SCD Type 1)
Slowly Changing Dimension Type 1 does not maintain history data and overrides the old data with new data and therefore does not track historical data at all. This is most appropriate when you don’t need to track the history of dimension and just want to update the correcting certain types of data errors, such as the spelling of a name or a date.
e.g. Consider SCD of Company.
| CompanyID | CompanyName | CompanyLocation |
| 1 | ABC Supply Company | Maharashtra |
If Company moves to new location and since its SCD Type 1 , We can simply update the table to overwrite data.
| CompanyID | CompanyName | CompanyLOcation |
| 1 | ABC Supply Company | Karnataka |
The big disadvantage to this method of managing SCDs is that there is no historical record kept in the data warehouse. However an advantage to this is that they are easy to maintain.
Did you enjoy this article? Please subscribe to Email or RSS to receive all the FREE updates!
Related posts: