Independent Data Marts


Independent Data Marts

I have the following architecture as my proposal(Using independent data marts). I request you to have a look into it and give your comments.

The INDEPENDENT DATA MARTS that i consider represents the same functional area but different geographic location (i.e.) all the data marts would contain the similar schema but will be distributed over the geography and the data local to that geography would be updated to those data marts directly.

My proposal also has all the independent data marts continuously updating the pre-defined aggregations to the CENTRAL FACT TABLE so that the top level corporate management can get the organization level reports directly from the aggregated fact table. The region level reports can be directly obtained from the data marts.

I have attached the details of this concept with this message.

Thank you