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...