The Reporting schemas are comprised of: Staging, Central and Datamart schemas. Source database or the operational database from which we want to extract our data from.
- Staging. The Staging ETL's are run, they pull any information from Source through to Staging
- Central. Once staging is populated with data the Central ETL's are run. These ETL's pull data into the Central Data Warehouse changing data where necessary and applying any business logic required..
- Datamarts. This is the final stage of the Reporting repository, data is transformed into dimensional format, and de-normalized to ensure ease of query, and to ensure cube builders/report builders find the data easer to model.