Five Stars

How to use inner join and left outerjoin in same job

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

  • Data Integration
2 REPLIES
Ten Stars

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

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.

Five Stars

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

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