Warehouse DataStage Question: Download Warehouse DataStage PDF

Explain How to handle the rejected rows in datastage?

Tweet Share WhatsApp

Answer:

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.

Download Warehouse DataStage PDF Read All 37 Warehouse DataStage Questions
Previous QuestionNext Question
Explain Dimensional modelling is again sub divided into 2 types?Explain What is job control?how it is developed?explain with steps?