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 ..
Hans is an Independent Business Intelligence and Datawarehouse Consultant & Microsoft SQL Server Consultant, working in the Netherlands.
He has been working in the software industry since 1996, with SQL Server since the year 2001, and since 2008 he has a primary focus on datawarehouse- and business intelligence projects using Microsoft technology, using a Datavault and Kimball architecture. He has a special interest in Datawarehouse Automation and Metadata driven solutions.
* Certified in Data Vault Modeling: Certified Data Vault 2.0 Practitioner, CDVDM (aka Data Vault 1.0)
* Certified in MS SQL Server:
* MCSA (Microsoft Certified Solutions Associate) SQL Server 2012
- MCITP Business Intelligence Developer 2005/2008
- MCITP Database Developer 2005/2008
- MCITP Database Administrator 2005/2008