Saturday, April 6, 2013

References for ETL Design Patterns talk

4/4 San Diego SQL BI User Group:

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)

CodePlex SSIS components

Thomas Kejser - early-arriving facts with partial-cache lookup & proc

Partition Mgmt project on CodePlex

Matt Masson - Design Patterns

Masson - SCD Tuning

Veerman - Project REAL

Jamie Thomson - blog

No comments:

Post a Comment