Chapter 2. Implementing a Data Warehouse

Exam objectives in this chapter:

  • Design and Implement a Data Warehouse

    • Design and implement dimensions.

    • Design and implement fact tables.

After learning about the logical configuration of a data warehouse schema, you need to use that knowledge in practice. Creating dimensions and fact tables is simple. However, using proper indexes and partitioning can make the physical implementation quite complex. This chapter discusses index usage, including the new Microsoft SQL Server 2012 columnstore indexes. You will also learn how to use table partitioning to improve query performance and make tables and indexes more manageable. You can speed up queries with pre-prepared aggregations by using indexed views. If you use ...

Get Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.