The main problem is always re-running warehouse population when using the check last day inserts/updates/deletes etc. With that logic you can end up inserting duplicate rows if you need to run a population through the day.

That's why we stamp a year/month column format (YYYYMM) and use that to determine the logic.

IE delete where YYYYMM = 200604, insert where YYYYMM = 200604 etc..

Good article, by the way. Highlights a lot of potential strategies.

Sigh. If only we can get the oltp guys to set databases up properly in the first instance, life would be a lot easier.