MAIN and LookUP

Six Stars

MAIN and LookUP

 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

Community Manager

Re: MAIN and LookUP

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: MAIN and LookUP

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

Community Manager

Re: MAIN and LookUP

Hi Yes, set Customer C as main, let me know if you have further questions. Regards Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: MAIN and LookUP

Ok thank you.
Regards
Sumanth

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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch