In the world of analytics and data warehousing, one of the trickiest challenges is keeping track of how things change over time. In operational systems, these changes often overwrite the old value without a second thought. But in analytical systems, overwriting the past can break your historical reporting. This is where Slowly Changing Dimensions (SCDs) … Continue reading Slowly Changing Dimensions