Archives of the TeradataForum

Message Posted: Wed, 03 Mar 2010 @ 14:57:58 GMT

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

We have a suite of processes that performs a similar, although not checksum function. These processes use TD metadata and SQL to perform column sums of specified columns (if numeric) or counts of unique values (if alpha-num) for given tables. This works for any number of rows, from a few rows into the billion+. This process is normally used to validate that the values in one table match another table, which should have the same content, or to compare a table, which exist on two TD servers and which should be identical on the two servers. This is an automated reporting process. However, I can see where it could be adapted to alert when the values in columns had changed, i.e. the table content had changed, and trigger the update process you mention.

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