tMap component used with tHashInput

[gcurato82]

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.

[Anonymous]

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.

[gcurato82]

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.

[Anonymous]

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

[gcurato82]

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