Issue with MLOAD Error tables

General

Issue with MLOAD Error tables

Hi,

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.

Tags (1)
4 REPLIES

Re: Issue with MLOAD Error tables

Hi HateOra

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?

Thanks

Sriveedam

Re: Issue with MLOAD Error tables

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.

Cheers,

Raja

Re: Issue with MLOAD Error tables

Hi Raja,

How to check the control file? That wil be internally generated by INFA..

Re: Issue with MLOAD Error tables

Did you check at TgtFiles directory or $PMTargetFileDir, If  not overridden at session connections level

control file has extension .ctl if I remember correctly.

If you are in unix environment you can do a global search using find with xargs.

something like this

find / -name "*.*" -type f -print 2>/dev/null|xargs grep DUPLICATE 

Cheers,

Raja