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.
Informix® Warehouse AcceleratorThe Informix® Warehouse Accelerator Administration Guide includes information about installing and configuring the accelerator server, creating data marts, accelerators, and accelerated query tables (AQTs).
Data marts and AQTsFor efficient query processing, the accelerator server must have its own copy of the data. The data is stored in logical collections of related data, or data marts. A data mart specifies the collection of tables that are loaded into an accelerator and the relationships, or references, between these tables.
Deploy and load the data martTo deploy a data mart, you specify the accelerator that will contain the data mart definition file. When you load a data mart, the related data is unloaded from the Informix® tables and transferred to the accelerator server.

Deploy and load the data mart

To deploy a data mart, you specify the accelerator that will contain the data mart definition file. When you load a data mart, the related data is unloaded from the Informix® tables and transferred to the accelerator server.

When you deploy a data mart, the data mart is in the LOAD PENDING state and is disabled until you load data into the data mart.

During the loading phase, for most data marts, the data is gathered from several different tables. After the data is loaded into the data mart, it is enabled automatically and is in the ACTIVE state. Loading data into a data mart can take several hours, depending on the size and the amount of data that is contained in the tables.

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.