Creating a Fact Table

Fact tables can only be created from a Stage table. The Ajilius workflow loads data, transforms that data through staging tables until it matches your desired fact, then updates the fact from that stage.

To create a fact table from a stage table, select the Create Fact option from the stage table context menu:

You will then be displayed a Fact edit form to set the table details:

Source Table Table from which this fact table will be created. This will be the FROM table in the query.
Table Name Name which will be used when creating the new fact table in the data warehouse. Must be lower-case with no embedded spaces.
Business Name Name which describes the business role of this table. This name will be surfaced through metadata in BI tools.
Transform Type

The transformation to be used when creating the fact table from the stage.

User and Technical Documentation Separate support for user documentation and technical documentation.