topic Re: How to do a Full outer join in talend using tmap? in Talend Studio

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

Ray0801 — Sun, 28 Mar 2021 09:50:16 GMT

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

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

Anonymous — Mon, 29 Mar 2021 02:57:08 GMT

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

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

manodwhb — Mon, 29 Mar 2021 04:47:21 GMT

@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

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

gjeremy1617088143 — Wed, 31 Mar 2021 08:27:24 GMT

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