In Part 1 of this blog I gave a theoretical overview of how to deal with slowly changing dimensions as well as some of the general advantages and disadvantages of each technique. Moving away from the theoretical overview and more towards the actual practice of the theories, my first attempt to handle slowly changing dimensions […]
Mike Burger
Blogs from this Author
Part 1 – The dimensions are supposed to change slowly, not the ETL
Overview: Although quite prevalent within the world of Business Intelligence, certain situations can still make handling slowly changing dimensions quite challenging. Just recently I had been tasked to deal with slowly changing dimensions in order to allow data within a dimension table to properly update while making sure to retain the history of the changes […]