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.
- 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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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.