Keep customers out of the DW Backroom

The backroom is ONLY for the ETL process, in other words, only for cleaning and preparing data from the raw systems and then passing it on to the presentation layer.

To this end, queries should NEVER be run in the backroom. If you start making exceptions and allowing end users or report developers to have direct access to the back room then you have fatally compromised the data warehouse.

References

• The Data Warehouse ETL Toolkit pg