BRidge table -Usage

View previous topic View next topic Go down

BRidge table -Usage

Post  SathyJaanu on Tue Oct 20, 2015 3:37 pm

I have a project table
activity table and Work order table.

One project has many Activities.Each activity is uniquely tagged to a project.
Similarly every project has workorders.Every work order is uniquely tagged to a project.
Every Workorder has may activities and is uniqely tagged to a Project .

I have designed a fact for WorkOrders ,Activities.

SHould i desgn a Bridge table for Linking WO's and Projects? and refer the key in Fact Activity?

What are uses of Bridge table and when to do we go for it?



SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: BRidge table -Usage

Post  ngalemmo on Tue Oct 20, 2015 3:47 pm

No bridge. The work order and activity facts would simply have a foreign key to the project dimension.

Bridges are used to resolve M:M relationships between facts and dimensions. You do not have that situation.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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