Using same oracle source for multiple joins

Six Stars

Using same oracle source for multiple joins

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


Accepted Solutions
Nine Stars

Re: Using same oracle source for multiple joins

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

OnetoMany.PNGOnetoMany1.PNG

 

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

 

Regards,

 

Veeru Boppudi

All Replies
Nine Stars

Re: Using same oracle source for multiple joins

Hi,

 

Please provide more details about your requirement.

 

Regards,

Veeru Boppudi
Six Stars

Re: Using same oracle source for multiple joins

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.

Nine Stars

Re: Using same oracle source for multiple joins

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

 

Regards,

Veeru Boppudi
Six Stars

Re: Using same oracle source for multiple joins

no my requirement is to use tjoin not tmap.

Nine Stars

Re: Using same oracle source for multiple joins

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

OnetoMany.PNGOnetoMany1.PNG

 

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

 

Regards,

 

Veeru Boppudi

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog