Five 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

1 ACCEPTED SOLUTION

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
5 REPLIES
Nine Stars

Re: Using same oracle source for multiple joins

Hi,

 

Please provide more details about your requirement.

 

Regards,

Veeru Boppudi
Five 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
Five 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