Business Intelligence Tutorial

What you just did

You defined the LOOKUP_MARKET dimension table in the Build Tutorial Market Dimension process, which contains three steps:

The sources and targets for each of the steps are:
Step Sources Target
Load Demographics Data Demographics file Demographics Target table
Select Geographies Data Geographies table Geographies Target table
Join Market Data Demographics Target table and Geographies Target table Lookup Market table

For this tutorial, you added the data links for each step while you were defining the properties of each step. Another way you can accomplish this task is to add all the steps in the process at one time, link the steps to their sources and targets, and then define the properties of each step. The Data Warehouse Center assigns default names to the steps that you can change in the Step notebook.


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