topic T Map without join in Talend Studio

T Map without join

Anonymous — Sat, 16 Nov 2024 05:58:07 GMT

Hello, I am new to Talend and rewriting some of the Talend code. The issue is there is a tmap that doesn't have a join condition but the ports from two pipelines are dragged to the target. How can this be possible? how can we join two pipelines without a join condition? details are below as i couldn't attach a screenshot.

Source 1: Flat file

columns: CODE STRING 5

Source 2: Mysql Table A

columns: STATE STRING 2

REGION STRING 5

The Talend tmap is used to join both the pipelines but I don't see both of them connected via a link that usually shows they are joined on that columns. Could you please help me out. TYIA. this would be a big help.

Regards,

Kiran

Re: T Map without join

vapukov — Mon, 29 Apr 2019 22:46:12 GMT

Hi,

without JOIN conditions it will be CROSS JOIN:

https://www.w3resource.com/sql/joins/cross-join.php

Re: T Map without join

Anonymous — Tue, 30 Apr 2019 14:42:48 GMT

Thank you very much vapukov. Is there a way you can share the screenshot of the tmap? Just wanted to make sure what ever i am looking for is same.

Here is my screenshot. Row1 and Row2 doesn't have a link which clearly says that there is no join condition. can this be considered as cross join?

thumbnail_IMG_9394.jpg