count comparison between two tables

[IamHulk]

Hi,

i need to create a job that will compare the source and target table counts.

i have source file with source schema,table name and target schema , table name i/p file having total 20 records.

please find the below picture here im getting source table count and target table count along table names but im not able to join two outputs can u suggest me how i can achive this?

in this job im passing schema name and table names from tflowtoierate as global variable

 

[TRF]

Did you try this design

The result for each tDBInput is used to populate a global variable.

Then you can compare the values of these variables to decide what to do next.