In this module, you will learn how to extend the data warehouse
schema to meet your measurement objective, and customize the extract,
transform, and load (ETL) process to publish the data you want. You
will add new dimension and new measures in the default schema. You
will learn how to create new dimension and fact builds in Data Manager,
deliver data to the data warehouse, and schedule the jobs for execution.
Finally, you will import metadata from the Data Manager, and make
the new component visible for publication in reports. By the end of
the module, you will have customized the data mart and the default
ETL process for your measurement objective.
Learning objectives
After completing
the lessons in this module, you will know how to do the following:
- Add tables to the default schema, and relate the tables to each
other
- Insert a data source into the data warehouse
- Add a new build for the data source, and schedule it for delivery
- Create queries from tables, and build relationships between queries
- Create a namespace for queries, and deploy the namespace for publication
Time required
Lesson 1 and 3 of this module
should each take approximately 20 minutes to complete; lesson 2 of
this module might take approximately an hour. The lessons might take
longer if you explore the related concepts.
Prerequisites
The default installation
of the following software is required for this module:
- IBM® Rational® Insight
- IBM InfoSphere™ Data Architect
In Lesson 2.1, you will use:
- IBM InfoSphere Data Architect. You can download
a demo version from http://www-01.ibm.com/software/data/integration/rda.
- Physical database models. You can install the database model when
installing IBM Rational Insight. The default location of
the sample model is C:/Program Files/IBM/Rational Insight/datawarehouse/dw.
In Lesson 2.2, you will use the Data Manager component of IBM Rational Insight. Data Manager can be used
only in a Windows® environment.
In
Lesson 2.3, you will use the Framework Manager component of IBM Rational Insight. Framework Manager can
be used only in a Windows environment.