Business Intelligence Tutorial

Defining a file 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:

  1. Right-click the Warehouse Sources folder.
  2. Click Define.

    The Define Warehouse Source notebook opens.

  3. In the Name field, type the business name for the warehouse source:
    Tutorial file source
    
  4. In the Administrator field, type your name as the contact for the warehouse source.
  5. In the Description field, type a short description of the data:
    File data for the TBC company
    
  6. In the Warehouse source type list, select Local files.

    The file that will be used in this exercise was installed on your workstation along with the tutorial, so the source type is Local files.

  7. Click the Files tab.
  8. Right-click in the blank area of the Files list, and click Define.
    Defining a File from the Files list

    The Define Warehouse Source File notebook opens.
    Figure db2tu009 not displayed.

  9. In the File name field, type the following name:
    X:\Program Files\sqllib\samples\db2sampl\dwc\demographics.txt
    

    where:

    On a UNIX(R) system, file names are case-sensitive.

  10. In the Description field, type a short description of the file:
    Demographics data for sales regions.
    
  11. Click the Parameters tab.
    The Parameters page of the Define Warehouse source File notebook
  12. Verify that Character is selected in the File type list.
  13. Verify that the comma is selected in the Field delimiter character field.

    As you saw in the lesson Lesson 3, Browsing the source data, the file is comma-delimited.

  14. Verify that the First row contains column names check box is cleared.

    The file does not contain column names.

  15. Click the Fields tab.

    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.

  16. Double-click the COL001 column name to change the column name.
  17. Type the new name for the column:
    STATE
    
  18. Repeat step 16 and 17 to rename the rest of the columns. Rename COL002 as CITY and COL003 as POPULATION.


    Figure db2tu036 not displayed.

  19. Click OK.

    The Define Warehouse Source File notebook closes.

  20. From the Define Warehouse Source notebook, click the Security tab.
  21. Select the Tutorial Warehouse Group to grant your user ID the ability to create steps that use this warehouse source.
  22. Click >. The Tutorial Warehouse Group moves to the Selected warehouse groups list.
  23. Click OK to save your changes and close the Define Warehouse Source notebook.


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