tJoin joins two tables by doing an exact match on several columns. It compares columns from the main flow with reference columns from the lookup flow and outputs the main flow data and/or the rejected data.

This component helps you ensure the data quality of any source data against a reference data source.

Check following job post for better use case.