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.
Subscribe to Email to receive all the FREE updates and Business Objects Interview Questions and Answers FREE!!
Related posts:
