Home
Data warehousingIn addition to designing and implementing Informix® dimensional databases, you can use tools to create data warehouse applications and optimize your data warehouse queries. The resources that are external to the information center are marked as such.
Dimensional databasesThe Informix® Data Warehouse Guide provides information to help you design, implement, and manage dimensional databases, and describes the tools that you can use to create data warehouses and optimize your data warehouse queries.
Implement a dimensional databaseYou will learn the SQL statements that you need to implement the dimensional data model
Implementing a dimensional data model and loading data with Informix® WarehouseYou can use the Design Studio provided with Informix® Warehouse to create a physical data model of your dimensional database based on your relational database. You can specify how to extract, transform, and load the data from your relational database to your dimensional database.

Implementing a dimensional data model and loading data with Informix Warehouse

You can use the Design Studio provided with Informix® Warehouse to create a physical data model of your dimensional database based on your relational database. You can specify how to extract, transform, and load the data from your relational database to your dimensional database.

Before you begin

For specific instructions on how to install and use Design Studio and other Informix Warehouse tools, see the Data warehousing and analytics node in the Informix information center.

About this task

To implement a dimensional data model and load data using Design Studio:

Procedure

Start Design Studio and create a new project.
Create connections to your existing relational database and the dimensional database that you will create.
Create a physical data model for the dimensional database. For example, you can:
- Reverse engineer the model based on the relational database schema.
- Manually create a model.
Design data flows that represent the movement of data from the source, through a series of transform operations, and into the target system.
Design control flows that define processing rules for the execution of a set of related data flows.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.