I have this structure in my source system.
I need to model this into a Data Vault 2.0 structure (I am using WhereScape).
If I model; as follows
I may have an issue with my PK; when a new record is added to Sat_Player_Salary. Two records will be added to Sat_Player_Salary.
What is the best way to structure the Player Salary Sat? Is it correct to be a child of Player Hub, or should it be a different type of table?