topic Re: Using same oracle source for multiple joins in Talend Studio

Using same oracle source for multiple joins

Anonymous — Thu, 12 Apr 2018 22:19:45 GMT

Hi,

Can someone help me understand how to join same source instance with multiple tables and connect the output of joins to tmap.

Thanks in advance,

crteja.007

Re: Using same oracle source for multiple joins

vboppudi — Thu, 12 Apr 2018 22:53:49 GMT

Hi,

Please provide more details about your requirement.

Regards,

Re: Using same oracle source for multiple joins

Anonymous — Fri, 13 Apr 2018 14:58:04 GMT

I want to use the same source for multiple joins with other tables. Since its not possible to connect the same source instance to multiple tables using tjoin on open studio am looking if there is any option to achieve.

Re: Using same oracle source for multiple joins

vboppudi — Fri, 13 Apr 2018 15:04:13 GMT

You can try with tMap. Where you can join same source with different tables as lookups.

Regards,

Re: Using same oracle source for multiple joins

Anonymous — Fri, 13 Apr 2018 16:59:27 GMT

no my requirement is to use tjoin not tmap.

Re: Using same oracle source for multiple joins

vboppudi — Fri, 13 Apr 2018 17:07:38 GMT

If you want to join single source with multiple tables you can join using tMap like below.

If you want to use only tJoin the you have to use more than one tJoin to join different sources with same source.

Regards,