Multiload Error (not all rows are being inserted)

Tools
Teradata Employee

Multiload Error (not all rows are being inserted)

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.

3 REPLIES
Junior Contributor

Re: Multiload Error (not all rows are being inserted)

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.

Teradata Employee

Re: Multiload Error (not all rows are being inserted)

How to check the error tables? The target table is set to Multiset so it should not reject duplicate rows

Junior Contributor

Re: Multiload Error (not all rows are being inserted)

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.