AnsweredAssumed Answered

MERGE Statement for insert/update

Question asked by sai.pokala335844 on Feb 21, 2018
Latest reply on Feb 21, 2018 by murali.yekola335627

Does Boomi support Merge statement to do insert/update at a time? If yes can some one help out how to create profile?

 

Sample data: 

MERGE INTO employees e     USING hr_records h     ON (e.id = h.emp_id)   WHEN MATCHED THEN     UPDATE SET e.address = h.address   WHEN NOT MATCHED THEN     INSERT (id, address)     VALUES (h.emp_id, h.address);

Outcomes