Automate T-SQL Merge For Loading Dimensions

If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve coded a couple of Merge statements, you might’ve noticed that most of that code is redundant. By saving source to target data map and other metadata before hand, you can automatically generate Merge statements to load slowly changing […]