Tmap vs Tjoin

Tmap Tjoin
We can create more than one output It has two default outputs one is “Main” and another one is ” Inner join reject”
You can write transformation using expression builder at each column level tJoin doesn`t offer this feature
In tMap you can filter data using filter expression tJoin doesn`t offer this feature
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
Expression in the columns while providing the joining condition Exact match between the keys of an expression
Support of multiple match models (Unique match, First match and All matches) Support of one match model (Unique match)
Storage of the look-up data on disk tJoin doesn`t offer this feature
Support of various look-up flows and can load multiple look-up flows in parallel Support of one look-up flow
Reloading of the look-up data for each main record tJoin doesn`t offer this feature
tMap take more space and time to load in the memory. tJoin take less time
tMap allows to store data on file option for lookup data processing tJoin doesn`t offer this feature