Is there anything like a table level checksum that could be used to see if two tables contain identical data? We are looking at replicating data and then applying daily updates and we want to know if there is any way to tell if two tables on different systems are identical.
Yes there is.
Come and join Partners 2012
Sunday 09:30 AM EST, Room: Baltimore 3-5
How to Compare Tables between Teradata Systems in a Dual Active Environment?