T Map without join

Highlighted
Five Stars

T Map without join

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


Accepted Solutions
Highlighted
Forteen Stars

Re: T Map without join

Hi,

 

without JOIN conditions it will be CROSS JOIN:

cross-join-round

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

 

cross_join.PNG

-----------

View solution in original post


All Replies
Highlighted
Forteen Stars

Re: T Map without join

Hi,

 

without JOIN conditions it will be CROSS JOIN:

cross-join-round

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

 

cross_join.PNG

-----------

View solution in original post

Highlighted
Five Stars

Re: T Map without join

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? 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read