Bridge tables and durable natural keys
Page 1 of 1
Bridge tables and durable natural keys
Hi,
in the Data Warehouse Toolkit, Chapter 9, Figure 9.7 shows the Management Hierarchy Bridge table joining the Manager Dimension and the Employee Separation Fact table (using surrogate keys). A couple of paragraphs below this it states "You could use durable natural keys in the bridge table, instead of the employee keys which capture type 2 profile changes."
Can anyone clarify how this use of natural keys would be implemented - does this require the natural keys to be added to the Fact table as well (which is, generally, not a recommended practice) or, if not, how are the bridge table and fact table joined?
Thanks,
Nick
in the Data Warehouse Toolkit, Chapter 9, Figure 9.7 shows the Management Hierarchy Bridge table joining the Manager Dimension and the Employee Separation Fact table (using surrogate keys). A couple of paragraphs below this it states "You could use durable natural keys in the bridge table, instead of the employee keys which capture type 2 profile changes."
Can anyone clarify how this use of natural keys would be implemented - does this require the natural keys to be added to the Fact table as well (which is, generally, not a recommended practice) or, if not, how are the bridge table and fact table joined?
Thanks,
Nick
nick_white- Posts : 364
Join date : 2014-01-06
Location : London
Similar topics
» Non-durable natural keys
» Composite Dimension Natural Keys - Attribute Used In Multiple Dimensions as well as Fact Tables
» Storing Date Keys in dimension tables versus fact tables
» Business keys or Natural keys in the Fact table
» Dimensions - To Create Based on Type or Role ?
» Composite Dimension Natural Keys - Attribute Used In Multiple Dimensions as well as Fact Tables
» Storing Date Keys in dimension tables versus fact tables
» Business keys or Natural keys in the Fact table
» Dimensions - To Create Based on Type or Role ?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum