topic Re: Comparison of data from 2 tables in Talend Studio

Comparison of data from 2 tables

Kaliana — Sat, 16 Nov 2024 05:00:37 GMT

Hello,

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

Thanks for help.

manodwhb — Mon, 12 Aug 2019 09:29:18 GMT

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

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

manodwhb — Thu, 12 Sep 2019 07:41:37 GMT

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

Kaliana — Thu, 19 Sep 2019 09:34:16 GMT

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

fdenis — Thu, 19 Sep 2019 09:45:02 GMT

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