Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 27 Sep 2011 @ 19:33:37 GMT

  <Prev Next>  
Next> Last>>  

Subj:   How to test if tables are in sync
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, September 27, 2011 15:25 -->


I'm trying to determine whether two tables on two different machines are the same.

I was considering using the hash functions against every column to produce a hash value that could be compared on each machine.


     (HASHROW( Col1 ,Col2 , Col3, etc  ))
            / ((HASHBUCKET()+1)/65536 )(BIGINT)) FROM myTable;

Now this does give me a value but I can't truly test it as the number of VPROCS is the same on both machines.

Will this work if the number of VPROC's is different? Does anyone have any other suggestion as how to test if the tables are in sync?


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