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.