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
(no tags)
- Downloads
Sorry, there are no downloads available for this session.
- SpeakerBIO
Mark founded Aphelion Software, specialising in the Microsoft platform. His credentials include publishing the first Sharepoint 2010 BI book and the new Visual Intelligence book.
Mark participates widely in the SQL and Sharepoint communities, having founded a BI user group, and assisting with SQL and Sharepoint saturdays, as well as being a frequent presence on the #SQLHelp and #SPHelp hashtags on twitter (@MarkGStacey)
- Video
The video is not available to view online.
- Session Files Explorer
The network name cannot be found.