DWH/BI - Integrating Data for Business Intelligence -is it worth the effort ?
ROI calculations apart putting a pure logic in place ->redundancy costs
and sometimes managing it another hell lot!!
Why can there be simpler ways to tackle this integration problem for purposes of Business intelligence
See below article from DM Review - a different approach-
http://www.dmreview.com/article_sub.cfm?articleId=1044329
Besides this there can be multiple ways/ solutions that can prove out to be cheaper from scenario to scenario the best suited way/solution may be implemented.
Best in terms of painless/ effortless transition to attain your GoaL.