Multicast transformation is useful when we need to make many copies of same data or we need to move the same data to different destination. It has one input and many outputs. The Multicast transformation distributes its input to one or more outputs.
Read
More here:
https://bageshkumarbagi-msbi.blogspot.com/2015/02/multicast-transformation.html
We are getting the excel having data
of multiple table value. We need to read the excel and store the data into the
multiple table based on the columns.
Below is the excel.
Each row having information about the below
o
Product category
o
Product sub category
o
Product
Below are the columns in Excel files
We will read the excel file and using the multicast and taking 3 destination to load the data into the respective table.
Here we are reading the data from excel file and mapping the columns on the respective table.
Below are the tables.
Now we are running the package.
Package executed successfully.
See the records in the tables.
We will perform the same thing without using the multicast transformation. In the next post we will see how can we achieve the without using multicast transformation.
No comments:
Post a Comment
If you have any doubt, please let me know.