From the course: Implementing a Data Warehouse SQL Server 2019
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Design dimension tables - SQL Server Tutorial
From the course: Implementing a Data Warehouse SQL Server 2019
Design dimension tables
- [Instructor] Now that we have a data warehouse database created for KinetEco, it's time to start creating 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 off of the date that the orders were placed and the customers that placed the order. So I'm going to create a dimension table for dates, and a second dimension table for customers, before we do that though, it might be a good idea to take a look and see how some of the example databases handle these same types of dimensions. Let's look in the WideWorldImporters Data Warehouse, and find a table called Dimension.Customer. I'll right-click on it and choose Select Top 1000 Rows. This dimension has a Customer Key that's the primary key for the table,…
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.