I need to load tables from SAS to Teradata. However, some rows are being rejected even when using Multiload. May I know what need to be done? Thanks.
Check the error tables to find out why the rows were not loaded.
There might also be Duplicate Rows and the target table is SET, removing them.
How to check the error tables? The target table is set to Multiset so it should not reject duplicate rows
The documentation link shows how to determine the cause of errors.
I don't know how SAS does it, but the default error table name are ET_target_table and UV_target_table, there are two columns, ErrorCode & ErrorField which contain details.