Today the subject of investigation is the Temporal Table, which is a new feature in SQL Server 2016. My focus will slightly be on how to use it in Data Warehouse environments, but there is some general information passing by as I write.
I want to cover next topics:
- What is a temporal table (in short)?
- Can I use a temporal table for a table in the PSA (Persistent Staging Area)?
- Can I use a temporal table for a Data Vault Satellite?
- Is using temporal tables for full auditing in an OLTP system a good idea?
The full article is posted on SQLShack.com, so read further there ..