Data Warehouse Best Practices
By Jean-Pierre Dijcks on May 18, 2010
In our quest to share our endless wisdom (ahem...) one of the things we figured might be handy is recording some of the best practices for data warehousing. And so we did. And, we did some more...
But the main topic of this post is the set of recorded best practices. Here is what is available (and it is a series that ties together but can be read independently), applicable for almost any database version:
- 3NF schema design for a data warehouse
- Star schema design
- Data Loading
- Parallel Execution
- Optimizer and Stats management
The best practices page has a lot of other useful information so have a look here.
Looks like some of these best practices recording have gone viral and are showing up on utube. Check out the best practices for a star schema on utube