How to get the reject records from join stage?

AvelinCorreia

 Profile Answers by AvelinCorreia Questions by AvelinCorreia

• Feb 23rd, 2012

If you want rejected records also, you need to use an outer join so that all the records are carried forward and then youll need to use next stage as a transformer. In the transformer, you can use appropriate condition in the constraints and redirect the unwanted records to a sequential file.

Bharath

• Feb 14th, 2012

Outside the join stage, you can put a filter to filter out the records having null values for the columns coming from right part of the join

Answer Question  Select Best Answer