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

One-to-many as Bridge

2 posters

Go down

One-to-many as Bridge Empty One-to-many as Bridge

Post  LuckyStrike Wed Mar 23, 2016 7:59 am

Hello,

our main Dimension has the following structure:

Company Dimension:

Division_Key
Division_Name
Company_Name
[..]

We have now a single case, where this is not sufficient. Our HR data fact table has the following structure:

Department_Key
Value
[..]

We don't need or report the department, only Division and Company. The mapping between Department and Division can Change.

Can we use a Bridge table for this:

Department_Key
Division_Key

If the mapping changes, I don't need to reload the fact table. All I have to do is to reload the Bridge.

LuckyStrike

Posts : 2
Join date : 2016-03-23

Back to top Go down

One-to-many as Bridge Empty Re: One-to-many as Bridge

Post  seemiyah Wed Mar 23, 2016 9:47 pm

I would solve this by maintaining both the current (Type1) and historical (Type2) values of the attributes in the dimension. This way you can report the facts at either state

eg
Department_Key
Division_Name
Historical_Division_Name
Company_Name
Historical_Company_Name

seemiyah

Posts : 2
Join date : 2015-08-18

Back to top Go down

One-to-many as Bridge Empty Re: One-to-many as Bridge

Post  LuckyStrike Thu Mar 24, 2016 2:24 am

Thanks for your reply. Our Company Dimension is SCD Type 2/3. Problem is, that most of our fact tables have only the Division_Key and not the Department_Key.

Therefore I want to use a bridging table. But I am not sure if this is the best solution.

LuckyStrike

Posts : 2
Join date : 2016-03-23

Back to top Go down

One-to-many as Bridge Empty Re: One-to-many as Bridge

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