how/ where to find reason for reject records

syam · Post by **syam** » 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.

us1aslam1us · Post by **us1aslam1us** » Wed Dec 27, 2006 9:26 am

On what constraints, Are you loading the data in the ODBC?

Sam

samsuf2002 · Post by **samsuf2002** » Wed Dec 27, 2006 10:55 am

where exactly you are capturing the reject records ? Are you getting any warnings . It might be data issue ,if u can capture the 36 rejected records try to analyze those records.

shilpa79 · Post by **shilpa79** » Wed Dec 27, 2006 1:12 pm

When you are trying to load into the table .Check the DDL how the table is created and check the key columns ,null values and duplicate records for the key columns and validate the data To check If you have any problem from the I/P data load into seq FF and then later into the DB.
So that you will know which records are getting rejected.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 27, 2006 3:55 pm

There is only one reason for import failure when using a Sequential File stage.

That reason is that the row does not match the record schema specified for the stage's output link.

The remaining diagnosis is up to you - the single column on the reject link is a Raw string (VarBinary).

You can view its contents using a Peek stage or writing it to a text file. If you know the layout, you can use a Column Import stage to parse it into columns.