Difference between tMap and tJoin component

 tMap and tJoin component are used for mapping data, it shows how to map, join, and filter data from input to output in both batch and real-time modes.

The difference between tMap and tJoin are as follows:-

• tMap accepts more than one input links i.e it has one Main and others are Lookup.

          tJoin accepts only two input i.e it has one Main and one Lookup link.

• tMap accepts more than one Outputs links. 

          tJoin which can have a Main and Reject links.

•  tMap supports more types of join model, includes Unique join, First join ,Inner join and Left Outer join .

           tJoin only support Unique join.  

• tMap support three match model i.e Unique Match,First Match and All Matches.
   tJoin support only Unique Match.

• tMap consist of multiple Lookup files.

          tJoin has only one Lookup file.

• tMap consist of Expression Filter so that we can filter our data.

          tJoin this is not possible.

• tMap we can use Expression Builder on the columns for complex transformation rules.

          tJoin this is not possible. Exact Match between the key is possible. 

• tMap support Die on error option.

          tJoin this is not possible.

• tMap take more space and time to load in the memory.

          tJoin take less time.