One of the things I’ve never really understood in data warehouse architectures is why there isn’t a feedback loop from Warehouse systems back to the operational source in other word Extract Transform Load and Feedback. Not saying the goal of most Warehouse projects isn’t to answer questions across the spectrum of operational systems. However data cleaning and profiling can detect many source system data issues and although validation reporting can pick up and address these issues it’s a pity there isn’t a feedback loop that provides source systems with fixes to their systems of considerable benefit to those sources. Of course this isn’t always possible for systems that are in archived state but for systems that are still active one would think that would be very beneficial.
I’m certain I’m not the only one to think this way so wondering if anyone has invented a system that provides updates back to sources so that issues can be addressed there?
TechnoBabel 