Skip to main content
Question

How to compare count of source query and target table and load data if counts are different.

  • September 24, 2019
  • 2 replies
  • 205 views

Forum|alt.badge.img

Hello Friends, I am new to FME, and I have a requirement to create a simple workflow. My requirement is as below.. 1. Get a count of rows from a source table ( in oracle) 2. Get a count of rows from a Target table ( in oracle). 3. If sourcen and target counts are different, then load Source table to target ( Truncate target table before loading.) How do I do it? what are the trasnformations I need to user. Could someone send me more detailed canvas pictures As soon as possible. Thank you for your help in advance.

2 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • September 24, 2019

I created a workspace that shows how to do this.

Hope this helps you getting started with FME.


Forum|alt.badge.img

Thank you Erik_Jan. Appreciate your quick response. I was able to create my job successfully. Thank you again.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings