Thanks guys, very helpful info.

one thing im not clear on. If have seen data warehouses being dropped and recreated then populated on a nightly basis. this obviously means the ETL has to be performed on all the data in the OLTP source to populate the warehouse. is this the norm? how would this scale up?

or would you be better to adopt a strategy of just updating the warehouse with only new data?