Different Match Models in tMap with example

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   sales
1           1000
2           2000
3           3000
2           5000
3           6000

3. First match

deptid   sales
1           1000
2           2000
3           3000