Generating an Initial Report

This section briefly describes the steps required to populate a report from the application. ETL is the process used to extract the data from the application database and bring it through to the datamart schema. For each schema, the data is extracted from the previous database, the data is transformed, i.e., inconsistencies are removed, etc., and the data is loaded in the new schema. Once the datamart is populated, the information can used in user friendly graphs and reports.