Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

BRidge table -Usage

2 posters

Go down

BRidge table -Usage Empty BRidge table -Usage

Post  SathyJaanu 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

Back to top Go down

BRidge table -Usage Empty Re: BRidge table -Usage

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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