Connections between Fact Tables

View previous topic View next topic Go down

Connections between Fact Tables

Post  Andy Nieubourg on Thu Sep 15, 2011 7:56 am

I'm currently devoloping a data warehouse for a small insurance company. While discussing the datawarehouse design, business users indicated various relationships between fact tables (for example: Claims and Benefits facts are stored in different fact tables (and have different corresponding dimensions) but a benefit is always linked to 1 claim (while 1 claim may have several benefits)). Is it wrong to link the claims Fact table directly to the benefit table? Should I try to identify common dimensions and link the fact tables like that?
Thanks in advance.


Andy Nieubourg

Posts : 6
Join date : 2011-09-06

View user profile

Back to top Go down

Re: Connections between Fact Tables

Post  VHF on Thu Sep 15, 2011 12:16 pm

Yes and Yes.

VHF

Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US

View user profile

Back to top Go down

Re: Connections between Fact Tables

Post  Andy Nieubourg on Thu Sep 15, 2011 4:02 pm

VHF wrote:Yes and Yes.

Brief and to the point. I guess I'll get to work and change those relationships. Thanks for the quick reply.

Andy Nieubourg

Posts : 6
Join date : 2011-09-06

View user profile

Back to top Go down

Re: Connections between Fact Tables

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum