1. Load the data into a multiset table. If the target table must be a set table, you can "insert ... select" into the target table from the multiset table, and duplicate rows will be suppressed automatically.
2. By default, character columns in Teradata have the NOT CASESPECIFIC attribute, which causes character values that differ only in case to be considered equal. You may need to explicitly specify CASESPECIFIC if the default is not suitable for your application.