Anindya1281

 Profile Answers by Anindya1281 

• Jun 4th, 2011

 

Hi

One way of connecting data from multiple datamarts is with the use of confirmed dimensions

Confirmed dimensions are dimensions which are shared between multiple fact tables within a datamart or between multiple datamarts

For example:
We have a company which provides banking and insurance solutions to customers
so one customer would have entry in banking datamart,credit card and insurance

so if we create a customer dimension with client id,customer id or party id.
then we can join multiple datamarts using this ID.

Thanks