Bridging Tables and Slowly Changing Dimensions
Page 1 of 1
Bridging Tables and Slowly Changing Dimensions
Hi,
I’m looking at building a bridging table between my customers dimension and accounts dimension, which will have the following attributes;
CUSTOMERS_BRIDGE
Account_id
Customer_id
Weighting_Factor
Holder_position
Holder_type
Begin_date
End_date
First_time_buyer_ind
My customer and account dimensions are both slowly changing dimensions with type 2 attributes. Should my bridging table only include the surrogate keys from my current records in each of my dimensions or should it include the history as well.
If I should include the history, how do I prevent this being confusing when reporting account to customer relationships? The begin and end dates on the bridging table would contain dates when a relationship started/ended and when a record in either of the dimension tables closed or was created.
I may have a relationship with multiple rows that have ended because these rows relate to changes in the attributes in the underlying dimensions but only relate to one closed relationship. How do I get around this issue or do you have another solution?
Also I have attributes on my bridging table that can be type 2 attributes (first time buyer indictor for example). Is it correct to have these on the bridging table and can I manage the changes of these too without confusing the account to customer relationships.
Many thanks
I’m looking at building a bridging table between my customers dimension and accounts dimension, which will have the following attributes;
CUSTOMERS_BRIDGE
Account_id
Customer_id
Weighting_Factor
Holder_position
Holder_type
Begin_date
End_date
First_time_buyer_ind
My customer and account dimensions are both slowly changing dimensions with type 2 attributes. Should my bridging table only include the surrogate keys from my current records in each of my dimensions or should it include the history as well.
If I should include the history, how do I prevent this being confusing when reporting account to customer relationships? The begin and end dates on the bridging table would contain dates when a relationship started/ended and when a record in either of the dimension tables closed or was created.
I may have a relationship with multiple rows that have ended because these rows relate to changes in the attributes in the underlying dimensions but only relate to one closed relationship. How do I get around this issue or do you have another solution?
Also I have attributes on my bridging table that can be type 2 attributes (first time buyer indictor for example). Is it correct to have these on the bridging table and can I manage the changes of these too without confusing the account to customer relationships.
Many thanks
kpdw166- Posts : 7
Join date : 2013-01-24
Similar topics
» Not so slowly changing dimensions
» Slowly changing heterogeneous dimensions
» Slowly Changing Dimensions Are Not Always as Easy as 1, 2, 3
» Unsure about relationship with Slowly Changing dimensions.
» Slowly changing fact with SCD2 Dimensions
» Slowly changing heterogeneous dimensions
» Slowly Changing Dimensions Are Not Always as Easy as 1, 2, 3
» Unsure about relationship with Slowly Changing dimensions.
» Slowly changing fact with SCD2 Dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum