Need to standardize below in Teradata. After standardization, tables should have:
Note: Above are the details given by Stanley. This may or may not be the final list
Out of Scope:
This will be a huge project, hopefully they pay you well.
If this is actually urgent you should try to get rid of it, it's way too late to ask right here and right now :-)
And it would be better to start at the LDM level, to ensure consistency across all tables.