SCD – Agile BI http://agilebi.com A community for sharing ideas about business intelligence development using agile methods. Tue, 22 Mar 2011 02:32:07 +0000 en-US hourly 1 https://wordpress.org/?v=6.2.2 Handling Advanced Data Warehouse Scenarios in SSIS http://agilebi.com/blog/2011/03/21/advanced-data-warehouse-scenarios/ Tue, 22 Mar 2011 02:32:07 +0000 http://6.1434 Continue reading ]]> For everyone that attended my presentation of “Handling Advanced Data Warehouse Scenarios in SSIS”, thank you. I’ve posted the slides, SSIS packages, and database script from the presentation on my SkyDrive. You are welcome to download them and take a look at the inner workings. A note of caution, though: please test these in your environment and with your data before applying the patterns everywhere. As I pointed out during the presentation, I had no foreign keys on the data warehouse I was using as a sample, and several of the examples used the technique of generating your own keys in the data flow. If you are using foreign keys or identity / sequence keys, you will need to make some adjustments to the patterns.

The presentation covers the loading of Late Arriving Dimensions, Parent-Child dimensions, Type 3 dimensions, and Type 6 dimensions. Over the next couple of weeks, I’ll be producing a series of blog posts detailing the patterns from the presentation in more detail. I’ll also cover a couple of bridge table patterns which I couldn’t squeeze into the presentation.

]]>