Which transormation logic, should i apply to process "N

sm.arunachalam · Post by **sm.arunachalam** » Mon Mar 17, 2008 3:33 pm

Hi,

I have a source in which more than 1000 EMP_IDs are there. I would like to process the ''Null'' IDs to Reject file and remaining to Output. Which transormation logic, should i apply? I would be very grateful to you guys. Thanks.

trammohan · Post by **trammohan** » Mon Mar 17, 2008 3:38 pm

There are number of ways to implement this... best way is to use filter stage ........

DSguru2B · Post by **DSguru2B** » Mon Mar 17, 2008 3:53 pm

Or using IsNull()/IsNotNull() functions in the transformer stage.