Critical success factors throughout the BI/DW lifecycle include:
The data warehouse and marts differ from that in applications as the data is organized by subject rather than function.
It is unwise to implement data quality checks to ensure that the copies of the attributes are correctly stored.
The CAP theorem states that at most two of the three properties: consistency, availability and partition tolerance can exist in any shared data system.