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

Bridge tables and durable natural keys

Go down

Bridge tables and durable natural keys Empty Bridge tables and durable natural keys

Post  nick_white Mon Jan 06, 2014 7:14 am

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

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

Back to top

- Similar topics

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