Hi Vaibhav,
I tried as per you suggested. Following image depicts sample job design. I load required fields from TableA and TableB, then join input.record.key with TableB's corresponding column in order to get TableB's ID. Then join TableA with Table B using the TableB's ID with corresponding column of the TableA in order to get the desired record from TableA (ID, Name from TableA).
When the job is run I noticed that the first join works fine and the ID is selected, but when join TableA with TableB using that ID it doesn't give any result (it seems the ID selected from first join doesn't pass to the second join)even though there are matching result for the join. What would be the reason for this?
Thanks and Regards,
Asanka.