Merge Byline Ssn with airSlate SignNow

Merge byline ssn

welcome to tech brothers with ahmed today we are going to answer this question if we have source s1 and source s2 and we need to merge them so that we get sorted output which transformation would you use in ssis so let's go to the ssd or bids and perform this real quick so to as we are talking about the transformation transformations are available in the data flow task bring the data flow task to the control flow pane and open it and as we are ready enough we need two sources so we are going to get two sources here i'm going to use the adb source and read the data from the sql table and uh here i'm going to read the data from customer table these are the columns i have let's go back preview the data it is returning as five records now i'm going to bring the second uh source that's also going to be an adb source i'm going to read from another table that's the customer underscore asia hit columns preview this is also returning us five records as our requirement in the question is we want to get the data from two sources so this one source one this is source two and then we want to generate a sorted output so what transformation we can use it the merge transformation is a transformation that accept so assorted inputs and it outputs a sorted data so that's the transformation we can use it uh here i'm going to use the the sort transformation to sort the data for source 1 and the source 2 and then just give input to the merge join uh merge i'm going to sort that add-on ids i can sort on in the different columns so whatever i wanted so i selected three columns in this case and i'm gonna get another sort and then join the second source and so the data on id name and first name one important thing we need to remember that the the names of the columns can be different when we are using in the merge but the metadata or the data type of those columns should be the same so we sorted them now connect to the merge and if you guys see that the only thing in the inputs it's in merge input 1 and merge input 2 so merge merge only acceptor 2 inputs and it gives us a 1 output that's important in the case of union all it can accept a multiple out more than even two and then give us output but that's not sorted output but we are looking right now where we can create sorted output so we need to use merge um transformation let's bring the multicast here and this will be used as a test purpose i can write directly to someone destination but i don't want to waste time on writing it uh and creating tables and...