T Map without join

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
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
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

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 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

An API-First Approach to Modernizing Applications

Learn how to use an API-First Approach to Modernize your Applications

Watch Now