Here are those references I mentioned in my 4/4 talk on ETL Design Patterns. Lots of good content in here. And for those that haven't studied Project REAL yet, definitely recommend giving it a look. Even though it is a few years old, still very relevant for many implementations.
Considerations for High Volume ETL Using SSIS (2008)
http://msdn.microsoft.com/en-us/library/cc671624.aspx
CodePlex SSIS components
http://sqlsrvintegrationsrv.codeplex.com/
Thomas Kejser - early-arriving facts with partial-cache lookup & proc
http://blogs.msdn.com/b/sqlcat/archive/2009/05/13/assigning-surrogate-keys-to-early-arriving-facts-using-integration-services.aspx
Partition Mgmt project on CodePlex
http://sqlpartitionmgmt.codeplex.com/
Matt Masson - Design Patterns
http://blogs.msdn.com/b/mattm/archive/2010/06/29/ssis-performance-design-patterns-video.aspx
Masson - SCD Tuning
http://blogs.msdn.com/b/mattm/archive/2010/08/05/optimizing-the-slowly-changing-dimension-wizard.aspx
Veerman - Project REAL
http://technet.microsoft.com/en-us/library/cc966416.aspx
Jamie Thomson - blog
http://sqlblog.com/blogs/jamie_thomson/
No comments:
Post a Comment