need of bridge table

View previous topic View next topic Go down

need of bridge table

Post  manickam on Mon Oct 21, 2013 6:56 am

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?


manickam

Posts : 27
Join date : 2013-04-26

View user profile

Back to top Go down

Re: need of bridge table

Post  LAndrews on Mon Oct 21, 2013 1:45 pm

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.


LAndrews

Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

View user profile

Back to top Go down

Re: need of bridge table

Post  ngalemmo on Mon Oct 21, 2013 2:46 pm

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

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

View user profile http://aginity.com

Back to top Go down

Re: need of bridge table

Post  Sponsored content


Sponsored content


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