Hi,

I'm working on a project at the moment where have an existing warehouse, and
need to bring in data from new source systems, which are from a similar (but
not quite the same) part of the business. These two parts of the business
merged recently, and they want to have a consolidated view of the data, as
well as replace some existing (Excel and Access based) reporting.

We are coming to the end of the analysis and design phase, and I want to get
some opinions that the approach I'm taking is valid.

I have tried to bring everything into the one database. I've added some new
fact tables for new source systems, as the original and new source systems
don't quite work the same. I've also tried to conform the dimensions as far
as possible, so that the data will aggregate consistently for the management
reporting.

This seems to fit pretty well, and I haven't had to alter the current data
model very much.

My question is basically: Is this the right way to go, or am I better off
breaking the warehouse into separate data marts?

A lot of the reporting will only apply to each part of the business, but
there will be some management reporting that wants a consolidated view of the
new merged business.

Any comments will be appreciated.

Thanks.