Is there any why I should not use a SQL Server Temporal tables for satellites? This would allow me to track changes to the data in the same way as using a hashkey.
If the data was streamed then they could also be used for effectivity satellites
Is there any why I should not use a SQL Server Temporal tables for satellites? This would allow me to track changes to the data in the same way as using a hashkey.
If the data was streamed then they could also be used for effectivity satellites
Effectivity Satellites have end-dates in DV2.0 too
Nope, if it works for you. End-dates in regular sats were deprecated because they were slow (pun unintended) to update and very large sats they become costly too. If you’re happy with those then there really is no reason why you couldn’t use SQL temporal tables for your sats.