In this module, you will learn how to add a new resource
and how to define which fields to extract into the data warehouse.
You will then define the flows for the data stream, from the source
of the data to the final location in the data warehouse. By the end
of this module, you will have customized the default ETL process to
load customized data to IBM® Rational® Insight data warehouse.
Learning objectives
After completing
the lessons in this module, you will know how to:
- Add new attributes to a data source.
You will do so in Lesson
1.1 by customizing the XML data configuration file, which is used
for defining the relationships between entities in a data source and
columns in a relational table.
- Push the new attributes into the data collection stream.
You
will do so in Lessons 1.2 and 1.3 by customizing the ETL catalog,
which is used for loading data to the data warehouse. In Lesson 1.2,
you will modify an existing build; in lesson 1.3, you will create
a new build.
Time required
Each lesson in this module
should take approximately 20 minutes to complete. It might take longer
if you explore the related concepts.
Prerequisites
The default installation
of Rational Insight is
required for this module:
Before you begin:
- You can download a sample Rational ClearQuest® database set here.
- Make sure that the sample database is installed and configured
according to the instructions in Preparation: Set up the sample
database.