Skip to main content
Question

compare the records for after read and before write

J

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

    3 replies

    J
    • jayd3vl
    • Author
    • August 14, 2018

    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

     

     

     

    ebygomm
    Influencer
    Forum|alt.badge.img+31
    • ebygommInfluencer
    • Influencer
    • August 14, 2018

    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

    J
    • jayd3vl
    • Author
    • August 15, 2018
    ebygomm wrote:

    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


    Most helpful members this week

    Community Stats

    30,846
    Posts
    116,937
    Replies
    38,670
    Members
    Terms & ConditionsCookie settings

    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
    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.