Page 1 of 1

capturing reject records in transformer stage

Posted: Thu Feb 15, 2007 11:38 pm
by syam
Hi All;

I want to capture the reject records that doesn't met the condition in the constraints . i checked the otherwise/log checkbox. but i cant able to capture the records thatdoesn't met the condition in the constraints. how i can capture those records?

Thanks;
Syam

Posted: Fri Feb 16, 2007 12:15 am
by ray.wurlod
Please post the constraint conditions for all outputs. To be passed to the Otherwise/Log output, the row must have failed to meet the constraint conditions for all prior outputs.

Verify (using Output Link Execution Order tool) that your Otherwise/Log link is executed last (unless you also have a reject output link).

Re: capturing reject records in transformer stage

Posted: Fri Feb 16, 2007 12:33 am
by sudeepmantri
Hi, I think u wont be able to capture the reject records in Parallel job in transformer. U got to use a server job

Posted: Fri Feb 16, 2007 12:44 am
by kumar_s
Capturing reject is possible both in Server as well as PX, constraints plays the key role for that.

Re: capturing reject records in transformer stage

Posted: Fri Feb 16, 2007 1:24 am
by ray.wurlod
sudeepmantri wrote:Hi, I think u wont be able to capture the reject records in Parallel job in transformer. U got to use a server job
Completely wrong. The parallel Transformer supports both an Otherwise/Log output (which corresponds to the server Transformer's reject output) and a reject output (which captures any input row that causes any exception within the stage's processing).

And I believe that we've already established that there is no user called "U" at DSXchange.

Posted: Fri Feb 16, 2007 7:42 am
by DSguru2B
We ought to create a user called "U". He is, apparantly, very popular :wink:

Posted: Fri Feb 16, 2007 7:46 am
by chulett
Along with his little brother, 'u'.