Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
without JOIN conditions it will be CROSS JOIN:
https://www.w3resource.com/sql/joins/cross-join.php
Hi,
without JOIN conditions it will be CROSS JOIN:
https://www.w3resource.com/sql/joins/cross-join.php
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?