Business Intelligence Tutorial

Lesson 8. Defining data transformation and movement

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:

  1. Loading the Demographics file into the warehouse database.
  2. Selecting data from the GEOGRAPHIES table and creating a target table.
  3. Joining the data in the Demographics table and the GEOGRAPHIES target table.

The end result is the LOOKUP_MARKET target table.


[ Top of Page | Previous Page | Next Page | Table of Contents ]