Currently Boomi offers the facility to write Insert/Update queries dynamically. Can we do likewise for MERGE also? Thanks.
Do you mean an UPSERT? Currently not, but you can vote on this idea: Dynamic Database Upsert . Btw: you can implement an upsert yourself with a PL/SQL stored procedure.
Retrieving data ...