How to handle the rejected rows in datastage?

Interview Candidate
Mar 2nd, 2006
2
12959

Showing Answers 1 - 2 of 2 Answers

satheesh_color
Profile Answers by satheesh_color

Mar 9th, 2006

We can handle by using constraints and store it in file or DB.

RamaPrasad Batchu

Mar 9th, 2006

we can handle rejected rows in two ways with help of Constraints in a Tansformer.1) By Putting on the Rejected cell where we will be writing our constarints in the properties of the Transformer2)Use REJECTED in the expression editor of the ConstraintCreate a hash file as a temporory storage for rejected rows. Create a link and use it as one of the output of the transformer. Apply either ofthe two stpes above said on that Link. All the rows which are rejected by all the constraints will go to the Hash File.