bi,

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.

But rapid decision-making with incomplete and imperfect information is the hallmark of intellect. Any fool can make decisions with all the information in front of him — and many do.

pretty surprised to read it on a BI site, nevertheless..

Whats latest in BI is efforts to Club all integration techniques and to deliver sense to the customer.Talking about delivering INFORMATION and not just data.The latest talks are on Semantics for the metadata , pretty interesting check the below for details

http://www.intelligententerprise.com/showArticle.jhtml?articleID=171000640&pgno=1