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

[Anonymous]

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:
 

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[swetha_molaka1]

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

Thanks in Advance!!

[Anonymous]

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

[swetha_molaka1]

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.

[Anonymous]

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