DSXchange

Here i am using Lookup stage, if the condition is not met i need to capture the records in target, where condition is not met need to load into reject file

Is it possible ??

Both the above mentioned conditions are the same !

yes

I need to capture where condition is not met and also
if the condition is not met also i need to load the data into target

Hi,

In the Lookup stage, use 'Reject ' option(for condition not met) and write the reject link to a copy stage.

From the copy stage you can capture the results and also write to a target (2 Streams) .