Clear all

Loading Links where source table only has primary keys and not business keys  

Posts: 8
Topic starter
Active Member
Joined: 2 years ago

Hi all,

I hope you are all well during these difficult times?

I have a question that I'm not entirely sure how to phrase and as such have struggled to find an answer on google and within this forum, but I would imagine it's a common question. It is probably best explained with an example (I'll use Kent Graziano's 2015 blog post entitled "Data Vault 2.0 Modeling Basics", as this nicely captures my problem).

In Kent's example, he has the following source system tables (snippet only).

And he has built out the data vault model as follows (snippet only);

OK, so I'm happy with the principle of using the business keys in the hubs and not the primary keys from the source system. However, I'm struggling to understand how you would load the Link from the source table? The Countries table contains only the primary key for the Region (REGION_ID) and not the business key (REGION_NAME). In my SQL script would I join both tables (Countries and Regions) to get the respective business keys?

Your help on this would be much appreciated.

17 Replies