Azure SQL Video
17 page views
1181 video views
2024, October 27, Sunday

#126 How to store change history in Azure SQL Server

How to: Create Type 4 Slowly Changing Dimension Using Azure SQL to Track Changes to Existing Records

We will know the techniques:

🔹What is the Slowly Changing Dimension (SCD, TYPE 4);
🔹Know the existing data (SELECT);
🔹Create history table (CREATE TABLE);
🔹Compare values between tables (MERGE)
🔹Store the output of the actions performed (OUTPUT, INTO, TABLE, INSERT, UPDATE);
🔹Insert action values into table variable (INSERT, SELECT) Store and view value changes (UPDATE, MERGE, SELECT)
🔹