Page 1 of 1

Oracle rejects

Posted: Mon Nov 28, 2005 11:14 am
by kollurianu
Hi All,

I have file having 276 records after some cleaning , total valid records are
270 and those should be inserted or rejects should be caught in the reject
file , but i see 270 going to ora oci table link and 0 records to reject link.
and 263 records are there in the target table , i am not able to understand
what happened to 7 records .

but for other file i have 100 recs and 99 got inserted and 1 record got rejected.

could some one help me what could be the reason?
any help greatly appreciated.

Thank you all

Re: Oracle rejects

Posted: Mon Nov 28, 2005 11:47 am
by Raghumreddy
1. Check your Condition again for the Rejects.
2. Check the datasage Log in Director what it says.
3. Check the condition in Insert Link also.


HTH
Raghu

Posted: Mon Nov 28, 2005 9:10 pm
by loveojha2
Hi Annapurna D Kolluri,
Check with your data, are there any duplicated rows coming from your source.