need of bridge table
3 posters
Page 1 of 1
need of bridge table
we have issues logged at
1. asset level
2. applicaiton level
3. process level
4. line of business level
5. combination of each of the above entities.
We planned to have dimension table for each entity (asset, application, process and line of business)
and a fact table which would have keys of all these dimensions and measures as ratings, score and status
As per the current requirement an issue can have multiple assets\applications\line of business.
So for this kind of scenarion can i have bridge table between the fact table and the respective dimension table?
1. asset level
2. applicaiton level
3. process level
4. line of business level
5. combination of each of the above entities.
We planned to have dimension table for each entity (asset, application, process and line of business)
and a fact table which would have keys of all these dimensions and measures as ratings, score and status
As per the current requirement an issue can have multiple assets\applications\line of business.
So for this kind of scenarion can i have bridge table between the fact table and the respective dimension table?
manickam- Posts : 27
Join date : 2013-04-26
Re: need of bridge table
You need to think about this differently.
The grain of the fact table determines the requirement for a bridge.
A bridge is required when a single fact record needs to join with multiple dimension records.
The grain of the fact table determines the requirement for a bridge.
A bridge is required when a single fact record needs to join with multiple dimension records.
LAndrews- Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada
Re: need of bridge table
As I responded to your previous post of the same question, I do not think a bridge table is appropriate unless this is a strict hierarchy. From the descriptions of the dimensions, it does not look like it. In such cases a fact with all the dimensions as independent foreign keys is the appropriate way to handle it.
Similar topics
» How to resolve a many to many relationship? Bridge Table or Utilize the same fact table?
» separate fact table/different grain - do I need a bridge table
» Data in a fact or dimenzion table or bridge table
» Bridge tables versus massive junk dimensions
» Bridge Table
» separate fact table/different grain - do I need a bridge table
» Data in a fact or dimenzion table or 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