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

need of bridge table

3 posters

Go down

need of bridge table  Empty need of bridge table

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

Back to top Go down

need of bridge table  Empty Re: need of bridge table

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

Back to top Go down

need of bridge table  Empty Re: need of bridge table

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

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

http://aginity.com

Back to top Go down

need of bridge table  Empty Re: need of bridge table

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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