Yeah that's a potential negative of the method. But I find significant performance benefits with all of it happening in the database as only rows that have changed need to be touched which in some cases outweighs the need to be 'clean'. Other methods require all data be moved or complex incremental logic created or SSIS used and there's pros and cons to each. This is just a way to do it all in SQL.