• A really good point, well made. As Joe says, using a staging area is best practice. However staging will never fully insulate you from the real world.

    In fact Obstacle Warehouse Builder offers this as a standard feature (this does not make up for all the other issues with WHB/Oracle) but the approach outlined is clearly best practice - if a lot more work.

    Thanks for putting in the effort to write this up.

    Pete