To minimize the effort for building up a suitable data cube, Interactive PMCube Explorer provides a wizard for data integration. Despite some configuration, it automatically performs the following integration steps:
- Generate the meta-data file from the selected source file
- Generate a database schema for the data cube from the selected meta-data file
- Import the data from data source into a temporary staging area table of the database
- Transform the data of the staging area table into the structure of the data cube
The data integration wizard assumes that there is an empty database instance that can be used for data integration.
The following sections give a brief overview of the configuration of the different steps.