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 |
The Blog focuses on all Related interview questions required at Scenario level with Solution description.
Tmap vs Tjoin
Subscribe to:
Posts (Atom)