From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Physical design for a data warehouse - SQL Server Tutorial
From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Physical design for a data warehouse
In this section, I'd like to talk about how the use of sequel server views, can improve the implementation of our data warehouse. The first situation we're going to look at is the snowflake dimensions. So, we have a dimension called Geography, that has a snowflake relationship to another dimension called sales territory. Both of these dimensions are interesting in and of themselves, but they're also interesting when we combine the data from the two tables. In your code, you could always reference each table individually. But it might be easier to create a view that pulls in a data from each table allowing us just to have one entity to look at all of the data. First lets look at the geography dimension. I'll right click and select the top rows. You may have noticed I have increased the font size in my management studio. We see that the geography dimension, contains information about countries, cities, states. Then if we scroll all the way to the right, we see it is linked by key to the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.