Why Warehouse?

Companies are finding that in order to be competitive, in whatever business, they must have easy access to information. Imagine that a sales manager approaches your boss and states that he needs to see the sales totals for a product across a region for the past several quarters to decide whether a certain group should be targeted for a new sales promotion. The executive knows that those doing order entry are capturing this information. He does not know that you are going to have to do some fancy pretzel-like maneuvers to pull up these sales totals. Over time, you provide him with the report and it ends up being not exactly what he wanted. The executive, now disgusted with the efforts of IT, resorts to having his secretary dump ...

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.