topic Re: How to use inner join and left outerjoin in same job in Talend Studio

How to use inner join and left outerjoin in same job

Anonymous — Wed, 21 Jun 2017 08:03:19 GMT

Hi experts,
I'm new to talend I'm confused with this issue how to give inner join and left outer join to same table
For ex: select * from products p,customers c,categories CT
Where c.cust_id = p.prdt_id
And c.dest_id =CT.cat_id(+)
How to execute above query in tmap
Please help me with this issue
Thanks in advance

Re: How to use inner join and left outerjoin in same job

cterenzi — Wed, 21 Jun 2017 16:51:22 GMT

If your customer, category and product data come from separate input components, then you can make customer your main flow and the others lookup flows. Within the tMap editor, you can specify the join type for the two lookups separately. Make the product lookup an Inner Join, and make the category lookup a Left Outer Join.

Re: How to use inner join and left outerjoin in same job

Anonymous — Thu, 22 Jun 2017 11:03:29 GMT

Thank you very much

But, what if I have query like this

select * from customers c,categories CA,products p,network n,pin_server pn,credit_transfer ch

where c.cust_id=p.pro_id

and c.dest_id=CA.cat_id(+)

AND ch.config_id = pn.config_id
AND pn.network_id = n.network_id(+)

In this case which component should be considered as main..

Thanks in advance