In this lesson, you will populate the LOOKUP_MARKET table by running the steps that you created in Lesson 8, Defining data transformation and movement:
You will then verify the results of running them.
Before you run the steps, you must promote them to test mode. Up to this point, the steps you created were in development mode. In development mode, you can change any of the specifications for the step. When you promote the step to test mode, the Data Warehouse Center creates the target table for the step. Therefore, after you promote a step to test mode, you can make only those changes that are not destructive to the target table. For example, you can add columns to a target table when its associated step is in test mode, but you cannot remove columns from the target table.
After you promote the steps to test mode, you will run each step individually. In a later lesson, you will specify that the steps run in sequence.