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

[Anonymous]

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.

[TRF · Accepted solution]

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.

[Anonymous]

Thanks @TRF  for tReplicate component

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

[Anonymous]

Hi @AkshayNG,

Please follow below screenshot to get that component

[Anonymous]

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