Archives of the TeradataForum

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

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

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