Independent Data Marts

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Independent Data Marts

Rate Topic

Display Mode

Topic Options

Author

Message

Pravin14u

Posted 2/23/2006 3:16:00 AM

Forum Newbie

Group: Forum Members
Last Login: 2/23/2006 2:52:00 AM
Posts: 1, Visits: 1

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

Prakash.P

Anna University,India