topic Re: MAIN and LookUP in Talend Studio

MAIN and LookUP

Anonymous — Wed, 05 Jul 2017 07:04:19 GMT

I'm facing issue with joins for example:

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

Re: MAIN and LookUP

Anonymous — Thu, 06 Jul 2017 05:29:49 GMT

Hi
It depends the join model and the output columns. Do you want to do left outer join or inner join? Which tables do the output columns come from?

Regards
Shong

Re: MAIN and LookUP

Anonymous — Thu, 06 Jul 2017 06:11:34 GMT

I want do both left outer join and inner join

as i mentioned in above query

and output columns come from customers c should I consider Customer C component as main...

regards,

Sumanth

Re: MAIN and LookUP

Anonymous — Thu, 06 Jul 2017 07:16:20 GMT

Hi Yes, set Customer C as main, let me know if you have further questions. Regards Shong

Re: MAIN and LookUP

Anonymous — Thu, 06 Jul 2017 07:44:09 GMT

Ok thank you.
Regards
Sumanth