One-to-many as Bridge

View previous topic View next topic Go down

One-to-many as Bridge

Post  LuckyStrike on 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

View user profile

Back to top Go down

Re: One-to-many as Bridge

Post  seemiyah on 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

View user profile

Back to top Go down

Re: One-to-many as Bridge

Post  LuckyStrike on 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

View user profile

Back to top Go down

Re: One-to-many as Bridge

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