count comparison between two tables

IamHulk — Wed, 05 Feb 2020 18:58:09 GMT

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

Re: count comparison between two tables

TRF — Thu, 06 Feb 2020 07:59:29 GMT

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.

topic Re: count comparison between two tables in Talend Studio

count comparison between two tables

Re: count comparison between two tables