topic Re: Join/Lookup with component that already has output to another component in Talend Studio

Join/Lookup with component that already has output to another component

Anonymous — Tue, 06 Jun 2017 10:53:08 GMT

Hi there,

As mentioned in the subject line, I'm trying to use tMap on components which already has output. For better understating of my problem, please have a look at below screenshot :

So I want to lookup SAMPLE MASTER with corresponding 3 sampple table/component. Is it possible ?

Thanks.

Re: Join/Lookup with component that already has output to another component

TRF — Tue, 06 Jun 2017 11:04:55 GMT

Hi,

No, you cannot. You need to rearrange the job like this:

Content of Smple_3 is memorized into a tHashOutput which is reused in a 2nd subjob as lookup for the tMap.

This is the idea.

Re: Join/Lookup with component that already has output to another component

Anonymous — Tue, 06 Jun 2017 11:43:31 GMT

Thanks @TRF for tReplicate component

But 'tHashOutput' component is unavailable on my side. I'm using TDI open studio 6.4. Any other way ?

Re: Join/Lookup with component that already has output to another component

Anonymous — Tue, 06 Jun 2017 12:01:31 GMT

Hi @AkshayNG,

Please follow below screenshot to get that component

Re: Join/Lookup with component that already has output to another component

Anonymous — Tue, 06 Jun 2017 12:30:14 GMT

Hi @TRF, I've tried the solution given by you, now its working. For better performance I've checked 'clear cache after reading' box.