Error: Error table already exists - Eventhough it was not present in the warehouse.
I am facing an issue with Mload and I am new to teradata. Actually 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:
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.
I released the lock and resubmitted the job..... BUT this time again I recieved Error1. I also tried dropping the base table but that too didn't work out.
Can someone share some insights on this. Any help will be appreciated.