topic tMap component used with tHashInput in Talend Studio

tMap component used with tHashInput

gcurato82 — Fri, 15 Nov 2024 22:16:30 GMT

hi community,

I have a question about the tmap component that was used in a Job.

in the job I have more tHashInput connected to the tmap, but in the map editor the join key is not inserted. is correct?

the task is used to divide the rows of a fixed text file into columns and write in a sql table.

Thank you for your support.

Re: tMap component used with tHashInput

Anonymous — Wed, 14 Dec 2022 17:25:42 GMT

Sorry, I am not sure what the question is here. But the fact that you are not joining your tMap inputs will lead to your main row records being multiplied by the number of records of every lookup input. If you have 4 unjoined inputs, each with 4 rows, you will get 4x4x4x4 = 256 rows returned.

Re: tMap component used with tHashInput

gcurato82 — Wed, 14 Dec 2022 18:10:13 GMT

Thank you for answering me. Actually maybe the question is not clear.

I would like to have the confirmation that in the tmap it is obligatory, in the case of multiple Input, inerire the key join.

Re: tMap component used with tHashInput

Anonymous — Wed, 14 Dec 2022 18:28:38 GMT

It is not obligatory, but if you do not, you will get the result I mentioned in my previous post.

Re: tMap component used with tHashInput

gcurato82 — Thu, 15 Dec 2022 07:32:42 GMT

Thanks for your confirmation. I thought it was as you said.