From the course: Data Science Foundations: Data Engineering
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Loading fact tables
From the course: Data Science Foundations: Data Engineering
Loading fact tables
- Okay now that we've got our dimensions loaded, let's take a look at loading fact tables. First we need to create our sales fact table. Then we'll insert data from our cleansed environment. And then we'll finish it off with doing a row count, just to make sure all the data was successfully migrated over. So here in my virtual machine, I have five underscore three dot sequel up. This is from our exercise files. And we need to copy this first step, which is to create the sales fact table. We're going to call it sales underscore all underscore years. It has all the data types and essentially everything from the cleansed environment ported over. Hit play, clear that query out. You should see the table pop up there on the left, and indeed it worked, with all the columns listed there. So step two is to insert the data from our cleansed environment to our new production one. So we're going to do insert overwrite into our new sales all years table with a select statement coming out of 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.