This doesn't seem to have received a lot of attention! Is it something still on your radar? The scope seems deliberately narrow, I'm guessing because there's still a handful of...
Yes - one of the reasons you might want a data warehouse is to to keep historical records when your source transaction systems don't, i.e. after they have been "purged"....
An approach I've taken to this in the past is to detect changes by comparing staged warehouse data against full source tables at every extract, with updates...
In some of my (ahem) less disciplined stored procedures the returned result set contains columns with no name (as a consequence of evaluating an expression...