SQL Table comparison

Hi

Is there a way to compare tables in 2 different databases using advanced ETL Processor?

We have an example explaining how to compare two files.
www.etl-tools.com/automation/0018-compare-two-files.html
You can use it as a starting point

Thank you for the response. Can i ask you or can i suggest that you make a video on how to push data from one table and use the transformer, validator to compare the 2 tables. My table has 15 columns but the example has 1 column so im stuck on how to add more columns and where to link them for comparison. The full breakdownmof how to compare big tables with more than 10 columns will be appreciated. Its a function we need to verify immediately.

The example provided demonstrates the principle.
Since you have more than one field to compare, you have to concatenate all of them together into one to make it work
You can use concatenate for that
www.etl-tools.com/wiki/advanced-etl-proc...laneous/concatenate/
Literally 2 minutes job

To avoid confusion here are some screenshots you may find useful.



Please keep us posted on your progress