Mload - errorlimit applicable only for ET during acquisition phase or also

Tools & Utilities
Enthusiast

Mload - errorlimit applicable only for ET during acquisition phase or also

Greetings Experts,

Does the errorlimit option does consider the records in ET during acquisition phase or even for the application phase of a Mload job?

For instance if errorlimit=10, after acquisition phase, no. of rows in ET= 8, during application phase some of the rows say 3 has errors and enter into ET table (not to UV table), there by making the no. of rows in ET=11 which is > errorlimit of 10.

Now, will the job terminate? 

If so, should I restart the job.  (will the restart succeed as the no. of rows in ET is > errorlimit) 

If it cannot be restarted, now the target table has to be manually restored from the backup (as the job has terminated in the application phase).

Tags (2)
1 REPLY
Teradata Employee

Re: Mload - errorlimit applicable only for ET during acquisition phase or also

Hi Cheeli,

Errorlimit option only applies to teh records in ET during acquisition phase. Thanks!