What is the difference between Merge and Union All Transformation in SSIS Package

In this video you will learn how to answer SSIS interview question "What is the difference between Merge and Union All Transformation in SSIS Package?"

You will learn
  1. How to use Union All transformation in SSIS Package
  2. How to use Merge Transformation in SSIS Package
  3. How to use Multicast Transformation for Testing purpose
  4. how to use Data Viewer in SSIS Package to view data while debugging

What is the difference between Merge and Union All Transformation in SSIS Package - SQL Server Integration Services(SSIS) Tutorial