Similarities and differences between a tJoin and a tMap component

Similarities and differences between a tJoin and a tMap component?

tJoin or tMap can both be used to create a join between different data sources. However, tJoin is a basic component only used to create a join between two data sources while tMap has other properties designed for different needs.

Note: tMap is an advanced component that can be used in more complicated cases than tJoin. However, tMap generates more code while compiling and may take more space and time to load data into the memory during the Job execution. Generally speaking, use tJoin if it suits your needs. Otherwise, use tMap.

You can find the differences between tJoin and tMap in the table below:

tJoin characteristics	tMap specific characteristics
Main and a reject output flow	Multiple outputs flows
An exact match between the keys of an expression	Expression in the columns while providing the joining condition
Support of one match model	Support of multiple match models (Unique match, First match and All matches)
Support of one look-up flow	Support of various look-up flows and can load multiple look-up flows in parallel
	Storage of the look-up data on disk
	Reloading of the look-up data for each main record
	Supports of the 'die on error' option.