We have a simple job that takes data from Oracle Enterprise stage and populates an SQL server table using ODBC enterprise stage.
Oracle Enterprise -> Transformer -> ODBC Enterprise
We have defined constraints on some of the fields in the SQL Server table. But even if the constraints are not met, the job runs successfully by rejecting the records (if we apply a reject link) or silently dropping them. We want the job to get aborted or at least throw a warning with the SQLCODE, if these constraints are not met.
Any ideas regarding this? Do we have to make any changes in the ODBC Configuration?
We are using DtaaDirect v6.0 drivers.
Job does not abort
Moderators: chulett, rschirm, roy