DSXchange

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.

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

Any Suggestions?

Any Suggestions?

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

- 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.

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.

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.