BRidge table -Usage
2 posters
Page 1 of 1
BRidge table -Usage
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?
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
Re: BRidge table -Usage
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.
Bridges are used to resolve M:M relationships between facts and dimensions. You do not have that situation.
Similar topics
» How to resolve a many to many relationship? Bridge Table or Utilize the same fact table?
» Data in a fact or dimenzion table or bridge table
» separate fact table/different grain - do I need a bridge table
» Bridge tables versus massive junk dimensions
» Bridge Table
» Data in a fact or dimenzion table or bridge table
» separate fact table/different grain - do I need a bridge table
» Bridge tables versus massive junk dimensions
» Bridge Table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum