Oracle stage Reject Link in Datastage
Posted: Wed Jun 20, 2007 12:14 am
Hi All,
We have created a job like ODBC -> Transformer -> Oracle -> Transformer -> ODBC
In this job we have enabled the Output Reject Records option for rejected records and we want insert these rejected records into SQL Server table (as ODBC stage).
We have tried with all the below options, but in all the cases we are not able to get the rejected records.
1) In source we have taken the NULL value which is Primary key in target, here the record is not rejecting it is just dropping and giving the warning.
2) In source we have taken the Decimal value which is Numeric in target, here the record is not rejecting it is just inserting as 0 in target.
3) In source we have taken the more length value compare to target length, here the record is not rejecting it is just truncating the value and inserting in target.
4) In source we have taken the Varchar value which is numeric in target, here the record is not rejecting it is just dropping and giving the warning.
Please let me know what might be the reason for not getting the rejected records. And in which case we can get the rejected records except the above 4 cases.
We have created a job like ODBC -> Transformer -> Oracle -> Transformer -> ODBC
In this job we have enabled the Output Reject Records option for rejected records and we want insert these rejected records into SQL Server table (as ODBC stage).
We have tried with all the below options, but in all the cases we are not able to get the rejected records.
1) In source we have taken the NULL value which is Primary key in target, here the record is not rejecting it is just dropping and giving the warning.
2) In source we have taken the Decimal value which is Numeric in target, here the record is not rejecting it is just inserting as 0 in target.
3) In source we have taken the more length value compare to target length, here the record is not rejecting it is just truncating the value and inserting in target.
4) In source we have taken the Varchar value which is numeric in target, here the record is not rejecting it is just dropping and giving the warning.
Please let me know what might be the reason for not getting the rejected records. And in which case we can get the rejected records except the above 4 cases.