IBM has published a brand new Redbook about Data Warehousing with Informix Dynamic Server:

• Data Warehousing with the Informix Dynamic Server

It is good to see that IDS is now a strategic IBM data server for OLTP as well as data warehousing. So there is no need for customers to establish a second database for their datawarehouse environment. The great flexibility and scalability of the Informix MACH11 technology together with the current and upcoming data warehouse functionality make IDS the optimal choice for the most demanding OLTP and data warehouse needs.

From the table of contents:

• Chapter 1. Introduction
• Chapter 2. Planning the environment
• Chapter 3. Informix Warehouse Client
• Chapter 4. Developing the physical model
• Chapter 5. Data movement and transformation
• Chapter 6. Deploying and managing Informix Warehouse solutions
• Chapter 7. Optimizing your Informix Warehouse environment
• Chapter 8. Moving forward with Informix Warehousing

An excerpt from the preface:

This IBM® Redbooks® publication discusses and demonstrates the capabilities
available with the IBM Informix® Dynamic Server (IDS) to develop and support a
robust data warehousing infrastructure. Those capabilities are delivered in
conjunction with the Informix Warehouse Feature.

IDS has the key characteristics necessary for a robust data warehousing
environment; and with the Informix Warehouse Feature, the design and
deployment of an Informix warehouse has become easier and more cost
effective with new Eclipse-based GUI tools. For example, there is a
state-of-the-art extract, load, and transform (ELT) tool for applying updates to the
data warehouse. The tool enables updates to be applied in a more continuous,
rather than batch-oriented process. Continuous updating becomes a key
requirement with the movement toward a real-time data warehousing
environment.

Using IDS for a data warehouse is an ideal solution for Informix clients who want
to build end-to-end analytics, reporting, and business intelligence solutions. The
data warehouse can be sourced from IDS and many other data sources. Clients
can more effectively use front-end analysis and reporting tools, such as IBM
Cognos®, and develop mashups and other dashboards. Informix clients can
simplify operational complexity and reduce costs by using a single database
server for both their operational and data warehousing environments.