How to do validation from one table to the other?

Load both the tables

Loop through the tables

Create a list combination of the records using variable substitution

Get Unique list of combinations using get_unique_list transformation

Get Unique list for both the tables

Using Sublist transformation get the list of records which are valid with the other table