Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 21 Dec 2007 @ 10:48:03 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Row CheckSum
From:   DWellman

Hi Bill,

At the point in your processing where you need to do this check I'm assuming that both sets of data (i.e. the 'new' rows and the existing rows) are in tables on TD. If that assumption is correct...

How about joining two tables with '=' on the key columns and '<>' on all other columns (handling NULLs as you go) ?

Or, how about using the ROWHASH function ? Again, joining two tables with '=' on the key columns and generating the ROWHASH value on all other relevant columns. If the ROWHASH is different then you know that you've got a different set of values. Even if the ROWHASH is the same then you may have to check each column value to finally check for different values.

Just a thought...



Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023