Unique Match: (Also called Last match) If several matches are found in the Inner Join, i.e. the last row matching the explicit join as well as the filter will be added to the output flow. First Match: If several matches are found in the Inner Join, i.e. the first row matching the explicit join as well as the filter will be added to the output flow. All Match: If several matches are found in the Inner Join, i.e. rows matching the explicit join as well as the filter, all of them will be added to the output flow Example: deptid sales 1 1000 2 2000 3 3000 2 5000 3 6000 Outputs: 1. Unique match deptid sales 1 1000 2 5000 3 6000 2. All matches deptid ...
Hello,
ReplyDeleteThanks for providing such a nice collection of Talend tutorials. helps me a lot.
nice content. Thanks for sharing this valuable
ReplyDeletecontent with us.