| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: how to handle the rejected rows in datastage?
|
| March 03, 2006 20:33:46 |
#2 |
| RamaPrasad Batchu |
Member Since: Visitor Total Comments: N/A |
RE: how to handle the rejected rows in datastage?
|
| 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. |
| |
Back To Question | |
