gadwalvr

 Profile Answers by gadwalvr 

• Jun 25th, 2007

 

The question itself is a little ambiguous to me. I think the answer to the question might be, we will place some conditions like 'where' inside the OCI stage and the rejected rows can be obtained as shown in the example below:
1) Say, there are four departments in an office, 501 through 504. We place a where condition, where deptno <= 503. Only these rows are output through the output link.
2) Now what we do is, take another output link to a seq. file or another stage where you want to capture the rejected rows. In that link, we will define: where deptno > 503
3) Once the rows are output from the OCI stage, you can send them into a transformer, place some constraint on it and use the reject row mechanism to collect the rows.

I am a little tentative because, I am not sure if I have answered the question or not. Please do verify and let us know if this answer is wrong.