Oracle rejects

[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

[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

[loveojha2]

Hi Annapurna D Kolluri,
Check with your data, are there any duplicated rows coming from your source.