O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Moving to Star Schema Loading

Now that you’ve validated, extracted, transformed, and staged your source data, you are ready to begin to load this data into your destination star schema and from there into your OLAP cubes. If you haven’t done so already, it’s time for you to update and verify your package documentation standards. By this we mean that you should be using standardized and meaningful names for packages, tasks, transformations, and so on. Much like commenting .NET Framework source code, properly documenting SSIS packages is the mark of a mature developer. In fact, when we interview developers as contractors on projects we often ask to review a couple of their past packages to get a sense of their method (and discipline) of working ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required