MS SQL Data Warehousing - Data Warehouse or Many Data Marts

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Data Warehouse or Many Data Marts

Joe

2006-10-25, 6:00 am

We have created a few data marts and have many cubes now. We are moving forward with a Reporting Services endeavor to get a common reporting platform. We have report servers that basically have dumps of our OLTP DB's.
a.. Isn't creating a big data warehouse the appropriate place to pull most reports?
b.. So what really is the difference between using a "data warehouse" verses "data marts" in creating cubes?
I think we need to have one big data warehouse for our reporrting needs, and as we create more cubes we create them from the dw - am I wrong here?

Sponsored Links