Bridge Tables
2 posters
Page 1 of 1
Bridge Tables
I have a SalesDim table that holds 3 users - Underwriter, SalesPerson and AdminSupportPerson (Fig.1)
Should these 3 users exist in the SalesDim table as foreign keys to UserKey in the UserDim (Fig.2) or should I build a bridge table SalesUserBridge (Fig.3) to hold the 3 users that sits between the Sales and User dimensions? Both would work I'm looking for best practice, I understand that when you have a one to may relationship between a fact table and dimension you should use a bridge table. Does this have benefits when you cube the data?
Regards,
Julian
Fig.1
SalesDimTable
SalesKey
UnderwiterKey (FK)
SalesPersonKey (FK)
AdminSupportPersonKey (FK)
Fig.2
UserDimTable
UserKey (PK)
Fig.3
SalesUserBridgeTable
SalesKey (FK)
UserKey (FK)
UserType (Underwriter,SalesPerson,AdminSupportPerson)
Should these 3 users exist in the SalesDim table as foreign keys to UserKey in the UserDim (Fig.2) or should I build a bridge table SalesUserBridge (Fig.3) to hold the 3 users that sits between the Sales and User dimensions? Both would work I'm looking for best practice, I understand that when you have a one to may relationship between a fact table and dimension you should use a bridge table. Does this have benefits when you cube the data?
Regards,
Julian
Fig.1
SalesDimTable
SalesKey
UnderwiterKey (FK)
SalesPersonKey (FK)
AdminSupportPersonKey (FK)
Fig.2
UserDimTable
UserKey (PK)
Fig.3
SalesUserBridgeTable
SalesKey (FK)
UserKey (FK)
UserType (Underwriter,SalesPerson,AdminSupportPerson)
juliang- Posts : 4
Join date : 2013-08-13
Re: Bridge Tables
Three keys, one for each role is the better approach. Bridges should only be used to resolve M:M relationships.
Similar topics
» Bridge tables issue
» ICD-10 and Bridge Tables
» Oh no, not Bridge tables again!!!
» BRIDGE TABLES
» Too many Bridge Tables...?
» ICD-10 and Bridge Tables
» Oh no, not Bridge tables again!!!
» BRIDGE TABLES
» Too many Bridge Tables...?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum