Create Fact Tables & Load Data-5

create the necessary fact tables (see Model Answer Key Download Model Answer Key) and load them from the staging tables that you created during Module 5. Remember, you are learning how to become a master builder so you want to take time to think about the steps you need to take to develop the dimension tables for your class project.

Use the following questions to think critically about how to add your dimension tables and load them.

Which table will I create first?
How do I find the information I need to load?
How do I Create and Delete tables?
How do I Insert the data into fact tables?


First, explore creating a single table such as Fact_ProductSalesTarget, loading it, and dropping it by hand. You can use the Snowflake interface.

Remember to save your code somewhere safe! I prefer GitHub but putting it on a flash drive or a cloud drive works too.

SQL commands needed:

Create Table
Drop Table
SELECT
INSERT


If you have any questions, remember to reach out to your peers, reader grader, instructor, and consult the materials provided to you. You shouldn’t need more than what you see here in this module.

Grading Requirements:

Data Warehouse is shared with the instructor and reader-grader.
Janak Rajani: PL68191
Mohit Shah: zj65542
Code is available in worksheet view.
Dimensions conform to the project dimension model answer key.
All data is loaded via script and not by interface.
Errors are handled.
Transformation of data occurs in the code; it does not occur in the spreadsheet.