I have just started using using temporal tables/system versioning, its very easy to setup and get going in terms of querying the data. The one thing missing for me is storing the change operation (update/insert/delete) or generating it on the fly from the system_time period. Can anyone point me in the right direction to achieve this? Or isn't this achievable?
Thanks in advance.