Comparison of data from 2 tables

[Kaliana]

Hello,

Need help please. How to compare data from 2 identical tables but in 2 different servers?

Thanks for help.

[manodwhb]

@Kaliana ,you can do in may ways and the one way is you can do using tmap below way.

https://community.talend.com/t5/Design-and-Development/How-to-compare-rows-between-two-tables/td-p/1...

if you have access to data quality you can try the below way.

https://help.talend.com/reader/SYA~BWHwsO0vEuiaWAEpTA/S6QBejHCyak6a6H9bWWePA

[manodwhb]

@Kaliana , If this issue resolved ,please mark the solution so that it would be useful to others. 

[Kaliana · Accepted solution]

Hello. Here is the methos I used. Thanks for your help.

[fdenis]

hi,

just to say that you are comparing only on one way.

you do no detect line only on table 2...

in this case I'm use to make an union of the 2 table then having a lookup of each distinct line in each table source (table 1 and 2).

with that method you can have a full comparaison.

good luck