To create the rest of the tables in the star schema, you must promote the steps that you created in Defining the rest of the tables for the star schema (optional). This section is optional, but if you do not complete the steps in this section, you will not be able to do the following lessons:
If you want to skip this section, go to Lesson 10, Scheduling warehouse processes.
To promote the steps, open the process that contains the steps, and follow the procedure in step 1 through 5. You do not have to test the steps as well. However, you can test the steps if you want to test them.
Promote the following steps:
Tutorial Process | Tutorial Step | Warehouse Database | Target Table |
---|---|---|---|
Build Tutorial Product Dimension | Tutorial Select Product | TUTWHS | LOOKUP_PRODUCT |
Build Tutorial Time Dimension | Tutorial Select Time | TUTWHS | LOOKUP_TIME |
Build Tutorial Scenario Dimension | Tutorial Select Scenario | TUTWHS | LOOKUP_SCENARIO |
Build Tutorial Fact Table | Tutorial Fact Table Join | TUTWHS | FACT_TABLE |