Maybe it would help you to categorize the issues, rather then pro/cons as each potential "pro" can be "con" depending on your point of view. The factors affecting the DW discussion are a combination of business and technology issues. Business people will want reports with a certain level of quality and timeliness. The infrastructure folks will want security and scalability and the other "abilities". The question for me is really, AS cube or no cube- relational reporting as it is called. Many times depending on the reporting need, a DW will be good enough. The case for a cube in my opinion is tied to aggregation and time analysis.
In the end the decision to use DW comes back to what are the reporting requirements.
Dig Deeper on SQL Server Data Warehousing
Related Q&A from Eric Brown
SQL Server expert Eric Brown helps troubleshoots an issue encountered when exporting to Excel. Continue Reading
SQL Server expert Eric Brown provides some helpful resources on business intelligence and data mining in SQL Server 2005. Continue Reading
Business Intelligence expert Eric Brown offers advice on decreasing the size of a datafile. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.