Lookup Stage - Rejection List

Raftsman · Post by **Raftsman** » Tue May 29, 2007 10:16 am

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

DSguru2B · Post by **DSguru2B** » Tue May 29, 2007 11:12 am

You can pass your stream through either a modify stage and use handle_null() or use IsNull() in transformer.

prasadduvasi · Post by **prasadduvasi** » Tue May 29, 2007 2:13 pm

You can use copy stage before the sequential file stage then you can handle nulls for the rejected records in the sequential file.