Rexell (12/13/2012)
Can you let me know if you know of any other legitimate reasons for implementing this solution or of any other potential pitfalls you may have seen when implementing it in the past please? Thanks.
I can tell you this kind of type 1 and type 2 transactional fact table data update collection is so popular now that M$ put CDC into SQL 2008 to make it easier to track and load into Data Warehouses and what I like to call Data Audit Warehouses.
Of course most anyone that is not the lead DBA or in executive management will see the goodness the provides.