We Informatica loading data into TD using MLOAD connection.
Here we have Error limit as '0'.
now we have seen a problem where in data is getting rejected but still the informatica job is completing and the error tables (ET/UV) are getting cleaned up.
I am not able to understand why the ET and UV are getting cleaned up. Ideally i shoud be cleaned up in the next run.
Could someone guide me, or atleast update me if this is possible that the records got rejected but no ET/UV existed? and MLOAD finished successfuly.
we are also in a similar situation and also I would i like to know if U were able to "release mload lock" through informatica.
if so , pls let me know how?
I am not able to understand clearly. However, I just smell a rat that mload has this option IGNORE DUPLICATE ...ROWS. Can you check the control file?
This is my initail thought.