Calculate Row/Table Level checksum in Teradata

Database
Enthusiast

Calculate Row/Table Level checksum in Teradata

We are offloading data from Teradata to SQL Server.We need to build a framework to reconcile the migrated data.Is there a method/function to calculate row level or table table hash values in Teradata(MD5/CRC32).I know for a fact there is a checksum level specified during table creation but we cannot get that from any dbc tables.Is there any other ways to retreive that information?

2 REPLIES
Enthusiast

Re: Calculate Row/Table Level checksum in Teradata

Look for HASH_MD5 function. I have used this function to calculate row level checksum

Teradata Employee

Re: Calculate Row/Table Level checksum in Teradata

The table checksum in Teradata is done at the block level and would not match anything that would be done in SQL Server since the internal representation of the data is very different.

 

Some searching in the forums here will find many posts about using MD5 or SHA in Teradata. It will be challenging to sucessfully perform hashing on two different databases in such a way as to have them match. The differences in data representation, character sets,... will make this very difficult. A better placce to start may be to do some basic aggregations - COUNT, SUM,... and then investigate the places where differences arise.