Skip to main content
  • EN

Hi There, In my fme workspace, I am reading from a SQL Server database. After few changes, I am writing to a SQL Server spatial database. I want to implement a check to see if the same number of records are written as the source and not sure of the best way to accomplish that. This is to check if there were any records missed during to any error. If that's the case, then I want to skip writing to the database. Thanks Jay

Just to add that I tried using statistics Calculator and I can do the test (in Count & out count) but I am missing the decision part if my condition matches then proceed with the update. Here is a snapshot of my current workspace.

 

 

recordcountcheck.pngrecordcountcheck.png

 

 

 

If you have done the test, the easiest way is to send the passed output port to a featuremerger, merge on 1 and then send the merged output to the writer. If nothing comes out the passed port then nothing comes out the merged port

If you have done the test, the easiest way is to send the passed output port to a featuremerger, merge on 1 and then send the merged output to the writer. If nothing comes out the passed port then nothing comes out the merged port

Thanks for the tip, it looks quite promising. I noticed that my tester isn't doing what I was expecting it to do. I have two statisticsCalulator, one just after reading data and other one placed after major changes are done, before writing. With Tester, I am just comparing the counts to make sure that all the records made it to the end. Not sure, what I am missing here.

 

Reply


Community Stats

30,363
Posts
115,370
Replies
38,141
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.