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.
you can use the MERGE statement instead of a standard insert/update statement. Use it as you would use the insert statement. If you need more information on the syntax check the Oracle documentation.
Retrieving data ...