Important Design Considerations
It is generally understood that most first-effort warehouses will fail or not live up to the original expectations. Reasons for failure include lack of adequate corporate sponsorship to neglecting to conform to a unified enterprise model. Whatever the case, there have been several success stories as well. Following is a list of tips that can help you build a successful warehouse or mart in your organization the first time.
Start small— The warehousing project is an iterative process. Build for specific applications that will offer immediate return on investment and end-user acceptance such as trend analysis, profit analysis, or expense reduction. This allows you to gain experience and still provide positive results. ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
