Conclusion
This first tutorial allowed you to get familiar with the Informix
Warehouse Feature so you can easily start using it.
This tutorial also introduced you to the context, architecture, and
components of Informix Warehouse. It illustrated with an example of
how to start using the Client component of the software, Design
Studio, in order to create a DW/ELT project, identify the connections,
and create the data models of the databases that will later
participate as sources and targets in the data movement and
transformation processes that will help to populate your data
warehouse.
This tutorial guided you through the process of designing the data
models of these databases to include the tables in the scope of the DW
solution using two different techniques: Discovering the
Entity-Relational model of a database using reverse engineering for
existing repositories with tables, or modeling the database from
scratch (from an empty template), based on the design we had
originally planned for the new warehouse repository, using the
graphical environment provided by Design Studio. These data models
remain part of the DW/ELT project and are exportable as templates or
DDL scripts, which you can validate, analyze impact of the desired
changes, and execute them directly against the actual databases using
Design Studio.
The following parts of this tutorial
series
will show you how to continue using Design Studio to now design the
data and control flows that will do the task of populating the new
data warehouse repository you have created in this tutorial, to
finally show you how to deploy and monitor those ELT jobs using the
Informix Warehouse Server component, the Administration Console.
| 
