Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

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

Hello,

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.

eg

     SELECT
     SUM
     (HASHBUCKET
     (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?


regards



     
  <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: 27 Dec 2016