Oracle Enterprise Stage Reject Link is not working

sohasaid · Post by **sohasaid** » Thu Mar 18, 2010 3:58 am

The Oracle enterprise stage performs a strange behavior here. The inserted data into the stage contains redundant data but it's not rejecting them although it inserts only the unique records into the database according to the primary keys? And there're no warning at the job log.

I'm enabling the 'Output Reject Record' option, anything else I've missed?

Regards.

ArndW · Post by **ArndW** » Thu Mar 18, 2010 4:15 am

If you are using upsert method, then no error would be generated, since the first record does an insert, the second an update.

sohasaid · Post by **sohasaid** » Sat Mar 20, 2010 3:48 am

Any Suggestions?

sohasaid · Post by **sohasaid** » Sat Mar 20, 2010 3:50 am

Any Suggestions?

chulett · Post by **chulett** » Sat Mar 20, 2010 7:52 am

Yes. Clarify your issue, especially your Write Method setting.

sohasaid · Post by **sohasaid** » Sun Mar 21, 2010 5:07 am

- Stage is Oracle Enterprise Stage
- The Write Method is 'Upsert'
- Upsert Order is 'Insert then Update'
- Upsert Mode is 'Auro-generted Update & Insert'

The data source table have no physical primary key but the destination have, I need to capture those records which are not inserted.

Regards.

chulett · Post by **chulett** » Sun Mar 21, 2010 7:24 am

Hmmm... as Arnd noted right away, any records 'not inserted' get updated. Why? Because that's what you told it to do. And an error is generated only if both actions fail, the insert and then the update.

sohasaid · Post by **sohasaid** » Sun Mar 21, 2010 9:04 am

chulett wrote: an error is generated only if both actions fail, the insert and then the update.

Got them. I changed the Upsert Mode to 'user-defined Update & Insert' and copied the insert statement to update statement place as I don't expect any updates. And I captured them.

Thanks Arnd & chulett for your help.
Regards.