View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
Source file will be divided into Multiple Destinations.
We have 3 Different Sources and want to Combine and Split the data and Load data into 2 Destinations.
We have 3 Sources i.e.
Source 1: Oledb
Source 2: Flat File
Source 3: Excel
Combine these 3 sources
First I want to combine 2 sources and make it as one source here I am using Merge Transformation like below fig…
Before going to join First I convert the data types by using Data conversion transformation why bcoz here our example we have flat file source when we join flat file source we must change the data types.
When we want use Merge transformation we must use Sort Transformation.
In this step I combine 3 Sources by using Union all Transformation it loads all data from multiple sources.
Then using Multicast Transformation we Split Data into Different Destinations
By using Derived Column Transformation Split Emp table Data
By using Another Derived Column Transformation Split Department Table Data
Load Employee Data into One Table/Destination and Dept Data into another Destination
Final out Put is
Other posts by Surendra