From the course: Implementing a Data Warehouse with SQL Server 2022
Join today to access over 24,900 courses taught by industry experts.
Design dimension tables - SQL Server Tutorial
From the course: Implementing a Data Warehouse with SQL Server 2022
Design dimension tables
- [Instructor] Now that we have a data warehouse database created for Kinetico, it's time to start creating some tables. I'll start with a couple of dimension tables, and in the next movie, I'll create a fact table to link them to. Let's suppose that the fact table will be about orders. Two common dimensions or ways that we might want to aggregate and group our order data together is based on the date orders were placed, and the customers that placed the orders. So, I'm going to create a dimension table for dates and a second dimension table for customers. Before we do that, it might be a good idea to take a quick look, and see how the example databases handle these same dimensions. Let's look in the Wide World Importers database first. Find the Dimension.Customer table, and I'll just select the top 1,000 rows of data. This dimension has a customer key that is the primary key for the table. It also has a WWI Customer ID…
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.