I have been using PeopleSoft campus solutions as one of the source systems for the data vault . Most of the tables have composite keys. In addition to the business keys there will be effective dates and even sequence numbers as part of the primary key . For example; table containing Academic Program codes along with other attributes has the academic program, effective date as the primary key. In this scenario, the satellite for the Academic program code cannot just contain the Hub academic program key and Load Date. I am thinking of adding a sequence number to make it multi active satellite. Is this really multi-active? Same code has different dates associated with it.
What will be the approach for modeling in these cases?