Azure Data Factory Variables are Problematic

I’m doing some Azure Data Factory work and encountered the problem alluded to in the Azure documentation, and I have to say Azure Data Factory variables are problematic. I created a pipeline which set variables inside a For Each activity. The documentation...

Merge for Loading Data Vault raw

When loading hub s and satellites the best option you have in SQL Server is to use merge for loading data vault raw. This is because it’s fail gracefully when it loads an existing hub id leaving out those in staging already loaded. It’ll easily insert new...