topic Re: [resolved] Issues with combining outputs from 2 tmap components using tunite in Talend Studio

[resolved] Issues with combining outputs from 2 tmap components using tunite

Anonymous — Fri, 15 Jul 2016 02:37:04 GMT

I am unable to join outputs from 2 tmap components using tunite. I have checked and made sure that the columns in both have same data type. Still, it is only allowing to connect just 1 output from tmap. Can you please help me in solving this.
Attaching snapshot of my current job:

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

Anonymous — Fri, 15 Jul 2016 04:11:32 GMT

Hi,
Thank you for your post! We can't see the screenshot on our side. Could you attach it on the forum, please? That would be great.
In addition, talend don't allow "Circle" in your work flow.
Please take a look at KB article about:TalendHelpCenter:Can I create a Job with multiple paths from a single source to the same target?
Best regards
Sabrina

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

Anonymous — Fri, 15 Jul 2016 04:28:53 GMT

Hi Sabrina,
Thank you for the response. I tried to attach a snapshot but it doesnt seem to upload to my post.
I will try to draw a picture of what i am doing :
redshiftqa --lookup--> tmap ----------------------------->
|(main)
postgresinput1 --> |
tunite --------> treplicate join the outputs from above 2 tmaps using tunite.
postgresinput2 --> |
|(lookup)
redshiftqa1 --main--> tmap(left join)----------------------------->

I am trying to perform a full outer join between source(postgres) and target(redshiftqa), and fetch out nulls. Those nulls would provide information as which data from source is missing in target and vice a versa.
I hope I didnot confuse you much.
Regards
Sunny

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

Anonymous — Fri, 15 Jul 2016 08:17:31 GMT

Hi,

redshiftqa --lookup--> tmap ----------------------------->
|(main)
postgresinput1 --> |
tunite --------> treplicate join the outputs from above 2 tmaps using tunite.
postgresinput2 --> |
|(lookup)
redshiftqa1 --main--> tmap(left join)----------------------------->

Talend don't allow "Circle" in your work flow. You have to redesign your work flow.
[font=Verdana, Helvetica, Arial, sans-serif]Have you already checked document about:TalendHelpCenter:Can I create a Job with multiple paths from a single source to the same target?[/font]
Best regards
Sabrina

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

Anonymous — Mon, 18 Jul 2016 05:32:23 GMT

Hi Sabrina,
Thank you so much for sharing the post. using thashoutput and thashinput solved my problem.
Thanks a lot for your genius advice.
Regards,
Sunny

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

Anonymous — Mon, 18 Jul 2016 08:46:45 GMT

Hi,
Great it is fixed. Could you please mark this topic as resolved?
Best regards
Sabrina

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

swetha_molaka1 — Tue, 06 Jun 2023 16:24:37 GMT

Using multiple tHash components is causing memory issue. Please refer the screenshot FYR. How can I join multiple outputs. Please suggest.

Thanks in Advance!!

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

Anonymous — Wed, 07 Jun 2023 06:49:27 GMT

Hello,

Is it possible to use a tFileOutputDelimited component to store the result with same target output (Append option) for your use case？

Here is a workaround to optimize the Job to reduce the size of the final generated code of a subjob.

https://community.talend.com/s/article/Exceeding-the-Java-bytes-limit-1Z1UZ

Feel free to let us know if it helps.

Best regards

Sabrina

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

swetha_molaka1 — Wed, 07 Jun 2023 07:10:03 GMT

Hi Sabrina,

Storing result in file/DB is not part of clients requirement. Hence looking for inbuilt talend components where it can store results temporarily.

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

Anonymous — Thu, 08 Jun 2023 06:53:51 GMT

Hello,

Could you please have a look at this workaround to divide the subjob into several subjobs to see if it could avoid this exceeding the Java 65535 bytes limit?

https://community.talend.com/s/article/Exceeding-the-Java-bytes-limit-1Z1UZ

Best regards

Sabrina

Re: [resolved] Issues with combining outputs from 2 tmap components using tunite

swetha_molaka1 — Thu, 08 Jun 2023 06:59:35 GMT

Sure, Thank you so much.