I worked on traditional as well as ipaas platform supported ETL tools. There I used to join (LEFT/RIGHT/INNER/FULL) data from two different sources.
Note: I think we can do joins in stored procedure if they are data base related. I am specifically looking for flat files.
Here I did not see such shape so that I can join sources based on my requirement. The only option I see is Map shape. But I think there it works like inner join
Please clarify my doubt and also help me understand map shape when we add another source in the same source profile.