Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Table level checksum for managing offline table storage
From:   Leslie, Quincy

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