Once data has been loaded from source systems into the data warehouse, the process of transforming it from its loaded state into facts and dimensions can begin.

The Transform menu guides you through this process.

There are three classes of transformation supported by Ajilius – staging tables, dimensions and facts.

Dimensions and facts should be clear to you. They are the user facing content of the data warehouse.

Staging tables are where the work happens in transforming the data we loaded into our ultimate vision of a data warehouse. Depending on the complexity of transformation logic required, data may pass through multiple staging tables before it is ready for presentation.

Menu Options

List Stage Tables Display the Stage Tables list.
List Dimensions Display the Dimension Tables list.
List Fact Tables Display the Fact Tables list.