Basic naming conventions

Ok, last question for a while and I’ll get stuck into reading other threads.

Given a team_member hub exists, and you have a source table that contains references to multiple team members:

  • manager;
  • assistant;
  • salesperson;
  • salesperson_alt.

How would you name the hashkey fields?

  • manager_hk;
  • assistant_hk;
  • salesperson_hk;
  • salesperson_alt_hk.

Would you then load each of these into your hub against the field team_member_hk, and the original field gets loaded against employee_id?

I hope that makes sense?

See: Data Vault Naming Standards. Data Vault as a practice is happy for… | by Patrick Cuba | Snowflake | Jan, 2023 | Medium