tMap is frequently used component for joins and lookup purpose, it is also use for verity of operations and transformations, whereas tJoin is used for join and lookups only.
tMap | tJoin |
It accepts more than one input one is main and rests of the lookups. | It accepts only two inputs and only one is main and other one is lookup. |
We can create more than one output | It has two default outputs one is “Main” and another one is ” Inner join reject” |
tMap has “inner join ” and ” left outer join” joining model | tJoin offer`s only “inner join” |
tMap offers three match model
| tJoin defaulted with Unique match |
tMap allows to store data on file option for lookup data processing | tJoin doesn`t offer this feature |
In tMap you can filter data using filter expression | tJoin doesn`t offer this feature |
You can write transformation using expression builder at each column level | tJoin doesn`t offer this feature |
