Business Intelligence Tutorial

Lesson 2. Creating a warehouse database

In this lesson, you will create the database for your warehouse and register the database with ODBC.

As part of DB2 First Steps, you had DB2 create the DWCTBC database, which contains the source data for this tutorial.

In this lesson, you will create the database that is to contain a version of the source data that is transformed for the warehouse. In Lesson 3, Browsing the source data, you learn how to view the source data. The rest of the tutorial teaches you how to transform that data and work with your warehouse database.

In this lesson, you will also learn how to register your database with Open Database Connectivity (ODBC), which allows tools like Lotus(R) Approach and Microsoft Access to work with your warehouse.


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