Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly

Thiemo Kellner <thiemo@xxxxxxxxxxxxxxxxxxxx> · Fri, 27 Oct 2023 11:34:02 +0200



    Hi
    Why do you need checksums? Can you not employ a full outer join?
      My though behind this is that checksumming is quite costly cpuwise
      and you have to fiddle with each and every relevent column, be it
      as part of the checksum string be it as part of the joiner. The
      joiner would have the advantage that you could, if you wanted,
      also implement logic to tell you precisely in which columns the
      difference is encountered.
    Kind regards
    Thiemo

    
    Am 27.10.2023 um 10:56 schrieb
      Y_esteembsv-forum:

    
        Hi 

        
        Need SQL
              logic/different approach method's  to find out way's 
        a) to Implement
              check sum to validate table data is migrated correctly  

          
        Any guidance
        

        Regards
        Bharani SV