Hello,
I have a job that loads data with Oracle Enterprise Stage, Upsert mode.
For some reason, like Foreign Key constraints or inserting Null into a Not Null column, I get rejected records, but it generates no warnings.
It just shows a Info message:
"ORA_TABLE,0: Records inserted: 0
Records used for update: 0
Records rejected: 1
Total records: 1."
I guess this is a normal behaviour for DS but I would like to be warned when this happens!
I whish it would be as simple as setting a variable (like APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS for string truncation) where we could say "DS, please warn me when there are rejected rows".
From your experience what solutions can I try?
Thanks in advance!
Reject records=No Warning, so how to detect rejected
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Wed Jun 15, 2005 9:27 am
-
- Participant
- Posts: 35
- Joined: Wed Jun 15, 2005 9:27 am
Oracle Connector
Solution: no more oracle enterprise stage, from now on I'll just use Oracle Connector stage.