From the course: Data Science Foundations: Data Engineering
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Loading the star schema
From the course: Data Science Foundations: Data Engineering
Loading the star schema
- [Instructor] Now if we think about how we're going to actually load that front office database that star schema that we built. Well first we need to insert and update any new dimension records. Then we can load our fact records because now we would have the associated dimensions to add those business keys. So if we look at this, here's our star schema and remember in the middle we have our sales fact table. And surrounding it we have all of the dimension data in some of the demos in this course we've built a few of these but essentially what we'd want to do is look for any new clients, products, locations, sources, or a time, that one probably doesn't change that much and load those records first. Then when we go to load our sales data, we're going to do lookups on all of those associated dimensions to find the ID values so when we load our sales data all of the IDs match and when analysts use that they can just do a simple join from sales or clients or products to complete their…
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.