topic Re: any option for cross join in Talend Studio

any option for cross join

Anonymous — Mon, 17 Sep 2018 15:54:53 GMT

hello everyone,

is there any way to apply cross join ?

i have 3 tables and want to get related data through cross join.

Re: any option for cross join

Jesperrekuh — Mon, 17 Sep 2018 16:38:22 GMT

Most easy is to do it at your database... just run the cross join on db-engine not in talend... prevent memory issues when you have a lot of records to join.

If you insist on doing it in Talend... tMap provides ways of doing this... read documentation :
https://www.talend.com/resources/configuring-joins-in-tmap/

Re: any option for cross join

Anonymous — Mon, 17 Sep 2018 17:07:50 GMT

I answered this in your first post....

https://community.talend.com/t5/Design-and-Development/any-option-for-cross-join/m-p/134088#M83546