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?