Using same oracle source for multiple joins

[Anonymous]

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

[vboppudi]

Hi,

Please provide more details about your requirement.

Regards,

[Anonymous]

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.

[vboppudi]

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

Regards,

[Anonymous]

no my requirement is to use tjoin not tmap.

[vboppudi · Accepted solution]

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,