In this lesson, you will define how the Data Warehouse Center is to move and transform data into its format for the data warehouse. First, you will define a process, which contains a series of steps in the transformation and movement process. Next, you will specify the source tables that are to be transformed for the warehouse. Finally, you will define data transformation steps that use two different methods of transformation:
Specifically, you will define the Build Tutorial Market Dimension process, which performs the following processing:
The end result is the LOOKUP_MARKET target table.