Yes i thought about that which was my thinking with having the raw tables and the staging tables. for example to build the DimCustomer i pull the transactional data into my RawCustomer tables which i then never update. I then Pull the customer data over into my StagingCustomer table and this is where i do my updating etc. I never thought about using views tho.