Notifications
Clear all

Business Table with History Spans.


Posts: 18
Topic starter
(@keithevans814)
Subscriber
Joined: 2 years ago

Hi All,

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?

Thanks

Reply
Topic Tags
21 Replies