Azure SQL Video
17 page views
1067 video views
2024, June 09, Sunday

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)
🔹