What is the difference between Lookup and Main?

[zedxu]

Hi,friends

What is the difference between Lookup and Main?

[Vineet]

Hi @zedxu,

"Main" is the one and only connection you can build from an input component to your o/p component via tmap or any other components.

every second input connection you make to your intermediate(tmap) or o/p component falls under lookup category.

Refer the below link for more information on how lookup works

https://help.talend.com/reader/SapKmX6pp8gru_C2cwvbvA/aP21iWfKK3Xlm65~A1p_Vw 

Thanks

Vineet

[zedxu]

Hi @Vineet,

Thank you for your answer.

My job's main and Lookup are using joblet as a data source,but the Main joblet must use a tOracleConnection or other DB connection component to read the data,therefore,I want to know the difference between lookup and main.

[Vineet]

Hi,

In that case, you would first need to connect your DB Connection component
to read the data to your job flow, then anything you add from this point
will become your lookups - like your joblets can be added as required to
the job flow.

Thanks