In this exercise, you will define a relational warehouse source called the Tutorial Relational Source. It corresponds to the GEOGRAPHIES relational table that is provided in the DWCTBC database.
To define the Tutorial Relational Source:
The Define Warehouse Source notebook opens.
Tutorial Relational Source
You will use this name to refer to your warehouse source throughout the Data Warehouse Center.
Relational data for the TBC company
Use the user ID that you specified when you created the sample database in Lesson 2, Creating a warehouse database.
Because the tables are in a DB2 Universal Database database, you can import the table definitions from DB2 Universal Database rather than defining them manually.
The Filter window opens.
The Data Warehouse Center displays a progress window. The import might take a while.
After the import finishes, the Data Warehouse Center lists the imported objects in the Available tables and views list.
The SAMPLTBC.GEOGRAPHIES table is moved to the Selected tables
and views list.
Adding the source to the Selected warehouse groups list authorizes the users in the group (in this case, you) to define tables and views for the source.
The Tutorial Warehouse Group moves to the Selected warehouse
groups list.
Accept the rest of the values in the notebook. For more information about the values, see "Warehouse Source" in the online help.