I have join two tables based on id columns using JOIN stage.
There are some reject means after joining two table some records are not satisfying the joining criteria . I would like to capture those records.
Any tips how to handle the rejects after joining?
Data's rejected in join stage cannot pass through the transformer after the join stage for the records which have been rejected initially.
If you are comparing two tables then you can use the Lookup stage for capturing the rejected records else try to capture the NULL records using the transformer before the join stage.
What you are looking for is an outer join... left/right/full depending on which side you are interested in finding these "rejects", then in subsequent stage identify those where left/right data is missing
or alternatively use the lookup with a fail condition to a new link