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 ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.