Solution: The solution of the above problem by using multicast and sort operations as follows.
• Using OLE DB Source to get data from the database.
• Multicast is used to one to many datasources.
• In Sort1 select 3 Input columns Product_ID, Product_Name, Product_Qty and Sort the data by using Product_ID.
• In Sort2 select 2 Input columns Tax_Rate, Tax_Amount and Sort the data by using Product_ID.
• In Sort3 select 2 Input columns Revenue_Rate,Total_Revenue and Sort the data by using Product_ID.
• Destination1 is used to store the values of Product_ID, Product_Name, Product_Qty and mappings are
• Destination2 is used to store the values of Tax_Rate, Tax_Amount and mapping are
• Destination3 is used to store the values of Revenue_Rate,Total_Revenue and mapping are
• Final Output with Data viewers
