We are trying to automate the metadata testing.
We have the following:
Date continuity checks to check whether the begin date of the next row follows the end date of the previous row
grain check checks for duplicates
Duplicate Surrogate id check,duplicate checksum
Checking for valid values -no nulls,0 type of checks
Foriegn key testing
Is there any other type of metadata testing that you do which I have missed out. Thanks in advance