I am facing an issue with Mload. We are loading in a table through Mload in Informatica. For the first time when I submitted the informtica job. It has given me the following error
Error1 - Message: [ERROR] Type:(Teradata DBS Error), Error: (Table 'I1103_EXT_R2_PRES_MT_PREV_ER1' already exists.)
I checked for this error table in the warehouse but didnt find one. Then I stopped the suspended Informatica job and deleted the related logtable in the warehouse and then resubmitted the job.
and this time I get the following error:
Error2 - Mload error: bad internal_status -Delete Mload Started while Import Mload suspended
This time, I released the Mload and again resubmitted the job..... But again I was getting Error1 .. I have also tried dropping the base table but that even didnt work.
Any help will be appreciated.
Which version of MLOAD are you using? And, if possible, can you share your MLOAD script?