All Forums General
HateOra 17 posts Joined 10/13
30 Dec 2013
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:
sriveedam 2 posts Joined 12/13
30 Dec 2013

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

Raja_KT 1246 posts Joined 07/09
31 Dec 2013

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

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

HateOra 17 posts Joined 10/13
01 Jan 2014

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

Raja_KT 1246 posts Joined 07/09
01 Jan 2014

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

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.