BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//SQLBits/com
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VEVENT
DTSTART:20120331T095000Z
DTEND:20120331T105000Z
LOCATION:SQLBits Conference - Epernay
SUMMARY:Loading Data Warehouse Dimensions in SSIS
DESCRIPTION:There are many different ways of using SSIS to load dimension data into a data warehouse. For small data volumes the method may not have much impact on the performance, but for high volumes making the right choice could be critical.

This session looks at some of the different methods available to load type 2 slowly changing dimension data into a data warehouse, including using T-SQL Merge, and compares the relative performance of these methods given different volumes of data.

We’ll also look at the impact of different storage solutions, comparing the performance difference of using FusionIO compared to traditional disks. Does the hardware platform change the design approach?

There are many different ways of using SSIS to load dimension data into a data warehouse. For small data volumes the method may not have much impact on the performance, but for high volumes making the right choice could be critical.

This session looks at some of the different methods available to load type 2 slowly changing dimension data into a data warehouse, including using T-SQL Merge, and compares the relative performance of these methods given different volumes of data.

We’ll also look at the impact of different storage solutions, comparing the performance difference of using FusionIO compared to traditional disks. Does the hardware platform change the design approach?

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, OLAP cubes, MDX and DAX using the SQL Server stack.

Alex has an MSc in Business Intelligence, runs the Midlands SQL Server User Group and the Birmingham SQL Relay conferences.

As well as speaking at SQLBits, he is also a regular speaker at other events including SQL Saturday, SQL Relay and SQL Server user groups around Europe.