All our database are run on Sun machines.
Anything up to E10000 with EMC arrays - CPU's varying from 6 to 52 and memory from 4Gb to about 32Gb+

The database I administer isn't datawarehouse, but I know we have a few running on the same hardware.

It's very quick and very scalable.