Page 1 of 1

Lookup Stage - Rejection List

Posted: Tue May 29, 2007 10:16 am
by Raftsman
I am passing rejects to a sequential file stage. Is there a way to setup the Null handling for Null fields. Unlike the non-rejects, where I can apply Null handling, rejects do not write to the file and I can't seem to apply Null handing to the fields.

Thanks

Posted: Tue May 29, 2007 11:12 am
by DSguru2B
You can pass your stream through either a modify stage and use handle_null() or use IsNull() in transformer.

Posted: Tue May 29, 2007 2:13 pm
by prasadduvasi
You can use copy stage before the sequential file stage then you can handle nulls for the rejected records in the sequential file.