Fact table for the data mart

Typical queries against a data mart join the fact table with the dimension tables and group information by a specific criteria.

When you specify the tables to use for the data mart, Informix® Smart Analytics Optimizer Studio automatically identifies the fact table in the warehouse on the Informix database server. The fact table is partitioned across the worker nodes of the accelerator server to reach a maximum degree of parallel processing.

The fact table for the data mart does not necessarily need to be the fact table in the warehouse that you created on the Informix database server.

By default, the largest table that you identify for the data mart is designated as the fact table by Informix Smart Analytics Optimizer Studio. However, you can specify any table that is part of a star or snowflake schema as the fact table for a data mart.