Both good points well made. first one answers my question on scaleability but also second one explains why the ETL's ive seen before do a drop of the DW first (the OLTP store was not massive).