how/ where to find reason for reject records
Posted: Wed Dec 27, 2006 7:10 am
Hi all;
Can you any body please guide me where i need to check reason(s) for reject records.let me explain some more details.
I am loading the data from source file(fixedlength flat file) to oracle data base.And i am capturing the reject records in sequential file. Log file is showing 1000 records imported succesfully and 36 records are rejected . but i am unable to find the reason in log file why it is rejected .
Used stages are sequential file and ODBC stages
Please let me know if need more details.
Thanks;
Shyam.
Can you any body please guide me where i need to check reason(s) for reject records.let me explain some more details.
I am loading the data from source file(fixedlength flat file) to oracle data base.And i am capturing the reject records in sequential file. Log file is showing 1000 records imported succesfully and 36 records are rejected . but i am unable to find the reason in log file why it is rejected .
Used stages are sequential file and ODBC stages
Please let me know if need more details.
Thanks;
Shyam.