I'd like to see a follow up article from the other side of the fence. De-normalizing the databaase for datawarehousing/reporting.

In my current contract, where we are building a small datamart, I've run up against a lot of resistance to denormalizing the database.

We've been able to alleviate some concerns by keeping the tables somewhat normalized and denormalizing via indexed views, but we still get a lot of weird looks.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface