Learn about the order by which to load data into a 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 analysis.
- Working with systems and schemas
- Managing of a good data pipeline
- Setting up an environment
- Loading and profiling data
- Testing quality
- Adding data types
- Handling missing values and inferred members
- Performing master data lookups
- Loading schemas and tables
- Creating views