How to do a Full outer join in talend using tmap?

[Ray0801]

I need to create a full outer join using a tmap for two tables in mysql,is it possible?

[Anonymous]

Hi

tMap only support left outer join and inner join, however you can do the left outer join two times using tMap, and then filter the duplicated records. eg:

table1--main--tMap1----tUnite1---tUniqRow---

|lookup

table2

table2--main--tMap2---tUnite1

|lookup

table1

Regards

Shong

[manodwhb]

@Merffi Ramesh​ ,check the below link the implementation of full outer join.

https://helicaltech.com/full-outer-join-by-using-tmap-in-talend/

Thanks,

Manohar

[gjeremy1617088143]

You can specify on you tMap output if you want the reject of the inner join , click on the Tmap settings of your output and choose Catch lookup inner join reject : true.

Send me Love and Kudos