Question

How do i compare data rows from two tables accross two databases?

  • 24 September 2019
  • 3 replies
  • 0 views

How do i compare data row count from two tables across two databases? Basically i am trying to load data if source has more rows than target table.


3 replies

Userlevel 4
Badge +30

Hi @rajan

 

Did you try to use the transformer FeatureMerger to compare?

 

Thanks in Advance,

Danilo
Userlevel 2
Badge +16

I created a workspace (without the data) that shows the workflow:

Hope this helps.

Thanks a lot for 1=1 trick was getting two separate rows and that was chocking point.

Reply