Need help please. How to compare data from 2 identical tables but in 2 different servers?
Thanks for help.
Solved! Go to Solution.
@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.
@Kaliana , If this issue resolved ,please mark the solution so that it would be useful to others.
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.
Tag as "solved" for others! Kudos to thanks!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Read about some useful Context Variable ideas