In this session
we’ll look at how T-SQL Merge can be used to perform complex multi-stage tasks
such as loading data into data warehouse dimensions, including the handling of
type 0, 1 & 2 slowly changing dimensions.
I’ll present a
summary of my MSc dissertation findings, comparing the performance of using
T-SQL Merge against other more traditional methods of loading data warehouse
dimensions in SSIS.
We’ll also look at
how we can use simple metadata configuration and dynamic SQL to completely
automate the generation of the merge statement, resulting in an incredibly
simple meta-data configurable data warehouse platform.
Alex is the owner
and lead consultant at Purple Frog, a SQL Server Business Intelligence
consultancy in the UK. He specialises in dimensional data modelling, data
warehouse design, ETL systems and Analysis Services. Alex is leader of the
Birmingham PASS chapter and runs the Midlands SQL Relay events. He has just
completed an MSc in Business Intelligence, writing a thesis on the performance
characteristics of loading type 2 SCDs into a data warehouse. He’s also a
regular speaker at SQLBits and at various SQL Server user groups and PASS
chapters around the UK.
8:50pm - 9:00pm Close