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