From the course: Implementing a Data Warehouse with SQL Server 2022
Join today to access over 24,900 courses taught by industry experts.
Design fact tables - SQL Server Tutorial
From the course: Implementing a Data Warehouse with SQL Server 2022
Design fact tables
- [Instructor] We've just created two dimension tables in the Kinetico Data Warehouse. Now it's time to create the fact tables for orders and connect everything together. Once again, let's take a quick look at an example of an orders fact table to see the kinds of fields we might consider including. There's a good one that you can find inside of the Wide World Importers data warehouse. It's in the fact schema. There it is, fact dot order. I'll just right click on it and select top 1000 rows. The first column, order key, is an auto incrementing integer that serves as the primary key for this table. Like most fact tables, you'll find lots of key columns that hold the foreign keys that relate to all of the dimension tables and provide the context. So here we have columns that connect to these city dimension, the customer dimension, the stock item dimension. Next, we have two that relate to the date dimension: order date…
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.