Dinesh Asanka
SSChampion
Points: 11100
More actions
September 16, 2026 at 12:00 am
#4922012
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing Dimensions in SQL Server
https://dbfriend.blogspot.com/
robert-819720
Mr or Mrs. 500
Points: 544
September 16, 2026 at 6:57 am
#4999187
Very interesting, but some of article appears to not publish properly and appears to me (both chrome on PC and on phone) as comments under text in "Implementation of Type 4 SCD" (after "maintaining a complete audit trail of historical changes")
Tinh Huynh
Newbie
Points: 2
October 13, 2026 at 9:21 am
#5064762
Based on https://www.kimballgroup.com/2013/02/design-tip-152-slowly-changing-dimension-types-0-4-5-6-7/ what you are writing is not Type 4. The correct one is Type 7: Dual Type 1 and Type 2 Dimensions.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply