Slowly changing dimensions- an integrated approach
There are many treatments of table design for slowly changing dimensions, and almost as many on doing ETL on an SCD. Much less has been said about building a cube around a slowly changing dimension.
In this session, Mark will review the types of slowly changing dimensions, describe the performance implications of various methods of loading SCDs in SSIS (SCD task, Lookups, Merge, and Script component), and build a unique way of using the versions in Analysis Services
Sorry, there are no downloads available for this session.
Mark Stacey founded the Aphelion Software Group, and works tirelessly to cross the business / technical boundaries in Business Intelligence, working in both SharePoint and SQL.
He has published 2 books on BI - Sharepoint 2010 BI and Visual Intelligence and frequently speaks at both SQL Saturday and SharePoint Saturday events.
He is one of the few Microsoft PDW trainers, and has trained in Africa, India and Europe on the PDW, as well as all over the world on other technologies
The video is not available to view online.