How to capture the rejected rows

sharathkedika · Post by **sharathkedika** » Mon May 05, 2008 7:58 am

Hi,

I have a job which pulls the data from XML file and inserts into a table. While reading the data from the XML , in XML-In stage i am getting a record count of 200 (which is correct) . but only 5% of the rows are getting inserted in to table.

I found that, couple of the elements in the XML file carring the wrong data(Elements of date type carring alphabets).

These rows are getting rejected at database level. If these are getting rejected at XML_IN stage , we can capture the rejected rows. But here I am not getting how to capture the rows which are rejected by Oracle stage.

Please help me out.

ArndW · Post by **ArndW** » Mon May 05, 2008 8:26 am

put a transform stage right before your DB write stage, and add a reject link to that transform. This is the way to capture rejects in DataStage server jobs.