4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

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
Presented by Mark Stacey at SQLBits XI
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    mark_stacey.jpg

    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

     

    http://markgstacey.net
  • Video
    The video is not available to view online.