any option for cross join

Anonymous — Mon, 17 Sep 2018 15:51:04 GMT

hello everyone,

is there any way to apply cross join through talend.?

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

Re: any option for cross join

Anonymous — Mon, 17 Sep 2018 15:59:18 GMT

If the tables are in the same database, just perform the cross-join there. Your DB components can handle ANY legitimate SQL.

If they are not in the same DB, you can achieve this by using two tMap components in the format shown below....

Dataset B Dataset C

| |

Dataset A ------> tMap_1--------->tMap_2------------>cross-joined content

Your Dataset A is fed into the tMap_1 as the Main flow. The DatasetB is a lookup which is not joined. Output all columns from that. Then connect another tMap with the output of tMap_1. Add a lookup with Dataset C. Do not join the lookup. Output all of the columns.

Every row that enters via the Main flow of tMap_1 will be multiplied by every row in Dataset B. Likewise, every row that enters tMap_2 will be multiplied by Dataset C.

Re: any option for cross join

Anonymous — Wed, 19 Sep 2018 09:19:44 GMT

Did this resolve your issue?

topic Re: any option for cross join in Talend Studio

any option for cross join

Re: any option for cross join

Re: any option for cross join