Demonstration of Multicast transformation in SQL Server Integration Services (SSIS)
More SSIS tutorials at http://www.analyticsinaction.com/category/data-integration/. SSIS demo of how to create create multiple identical data streams from single source using SQL Server Integration Services.
I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF