Logo DWBI.org Login / Sign Up
Sign Up
Have Login?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Login
New Account?
Recovery
Go to Login
By continuing you indicate that you agree to Terms of Service and Privacy Policy of the site.
SSIS

SSIS- Multicast Transform

 
Updated on Sep 30, 2020

This is a Fast Forward tutorial on Multicast Transformation in Microsoft SQL Server Integration Services.

Multicast Transformation

The Multicast transformation distributes its input to multiple outputs. It basically creates copies of an input dataset. This transformation has one input and multiple outputs. It does not support an error output.

Implementation

Here we want to create two copies of the source employee table data.

Control Flow
Control Flow

Here we have EMP table as OLEDB Source. Next we use a Multicast transform to create two copies of the employee dataset followed by two Flat File Destination as targets.

Data Flow
Data Flow

We can create as many copies of the input dataset we want. Below the properties of the transform viewed in Multicast Transformation Editor.

Multicast Transformation Editor
Multicast Transformation Editor
Multicast Transformation Editor
Multicast Transformation Editor

Use Multicast transformation to apply multiple sets of transformations logic to the same data set.

Multicast Transformation- Properties
Multicast Transformation- Properties

For example, one copy of the source data can be used to load the dimension table, while another copy of the data is extended with lookup values and derived columns and aggregated before it is loaded into the fact table.

PrimeChess

PrimeChess.org

PrimeChess.org makes elite chess training accessible and affordable for everyone. For the past 6 years, we have offered free chess camps for kids in Singapore and India, and during that time, we also observed many average-rated coaches charging far too much for their services.

To change that, we assembled a team of top-rated coaches including International Masters (IM) or coaches with multiple IM or GM norms, to provide online classes starting from $50 per month (8 classes each month + 4 tournaments)

This affordability is only possible if we get more students. This is why it will be very helpful if you could please pass-on this message to others.

Exclucively For Indian Residents: 
Basic - ₹1500
Intermediate- ₹2000
Advanced - ₹2500

Top 10 Articles