In the next few lessons, you will focus on defining the Market dimension table that was introduced in Tutorial business problem. In this lesson, you will define warehouse sources, which are logical definitions of the tables and files that will provide data to the Market dimension table. The Data Warehouse Center uses the specifications in the warehouse sources to access and select the data. You will define two warehouse sources that correspond to the source data that you viewed in Browsing the source data:
If you are using source databases that are remote to the warehouse server, you must register the databases on the workstation that contains the warehouse server.
The sample warehouse sources do not have a user ID and password associated with them. You need to add a user ID and password before you can work with these sources. In this exercise, you will add a user ID and password for the TBC Sample Sources.
To update the TBC sample sources:
The Properties -- TBC Sample Sources window opens.
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 Creating a warehouse database.
Because the tables are in a DB2 database, you can import the table definitions from DB2 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 tables in the Available 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.
In this exercise, you will define a file warehouse source called the Tutorial File Source. It corresponds to the Demographics file that is provided with the Data Warehousing sample. For this tutorial, you will define only one file in the warehouse source, but you can define multiple files in a warehouse source.
To define the Tutorial File Source:
The source type is Local files because the file that will be used in this exercise was installed on your workstation along with the tutorial.
The Define Warehouse Source notebook opens.
Tutorial file source
File data for the TBC company
The Define Warehouse Source File notebook opens.
X:\Program Files\sqllib\samples\db2sampl\dwc\demographics.txt
where:
On a UNIX(R) system, file names are case-sensitive.
Demographics data for sales regions.
Demographics Data
As you saw in the lesson Browsing the source data, the file is comma-delimited.
The file does not contain column names.
The Data Warehouse Center reads the file that you specified on the Warehouse Source File page. It defines columns based on the fields in the file, and displays the column definitions in the Fields list. It displays sample data in the File preview area. Up to 10 rows of sample data are displayed. You can scroll to see all the sample data.
STATE
The Define Warehouse Source File notebook closes.
In this lesson, you defined a relational warehouse source and a file warehouse source. You will use these sources in Defining data transformation and movement to indicate that these sources provide data to the LOOKUP_MARKET dimension table for the star schema that you are defining for the TBC Company.