Here is a video I found on the topic:
https://www.youtube.com/watch?v=04_esxp8C_o
The video covers some of the basics including how to version, reproject, handle “Errors” and mask invalid data.
Here is an article on Evolving Data Warehouses:
https://www.sqlshack.com/implementing-slowly-changing-dimensions-scds-in-data-warehouses/
I have a theory that the two topics are at least similar enough to consider using across the two domains.