Business Intelligence - Data Cleansing in a Data Warehouse

http://www.youtube.com/watch?v=oM1Isda4v7c In this video Dan goes over some Business Intelligence best practices such as why it's a bad idea to add business rules to any Data Warehouse loading routines. The Data Vault methodology explicitly asks you not to do this.

The core Data Vault methodology forces you to move "soft" business rules downstream of the Data Warehouse. There are specific reasons for this.