This has been Achieved through Merge failure can get the single File and do the required transformation and then to place the file in destination. ... View more

Got this Scenario successfully  using Query Record Processor. Written SQL query with UNION ALL ( Select col1, col2, ..... From tb1 where 'participant status' <> 'inactive'   UNION ALL   Select col1, col2, .. '', '', '', '' FROM tb1 where 'participant status' = 'inactive' ) ... View more