SET operations provide powerful capabilities in combining or filtering data between multiple tables. In this video, I am showing the usage of SET operations in SQL Server 2019. We shall use the similar concept in Data warehousing during incremental load.