Error while loading multiple files in Teradata using Multiload.

Tools & Utilities
Enthusiast

Error while loading multiple files in Teradata using Multiload.

HI,
I am loading 2 input files into Teradata in a single Multiload script, but multiload behaves unpredictably and loads the rows into error tables(both UV and ET). However, when loading the same files using same script but one at a time in 2 seperate loads it works fine. Since, in Test environment I submit the job twice for each file, however this is not possible in Production, Please let me know if any one has solution to this or faced similar kind of issue.

Thanks in Advance
Manoj Kumar Parmar
2 REPLIES
Teradata Employee

Re: Error while loading multiple files in Teradata using Multiload.

Please provide the entire script.
Also, are the rows placed in the ET or UV error table?
-- SteveF
Enthusiast

Re: Error while loading multiple files in Teradata using Multiload.

If rows are placed in ET/UV table then please post the error message you are getting along with the script.