I don't see an option to do Dynamic upsert while using the Database shape as target, My source is workday, is there any work around to do the upsert in the target DB?
Do you want to write queries dynamically?
If yes, you can achieve this by a groovy script.
The database connector does not support an upsert action, in part because support for that behavior varies across database vendors.
Would it be feasible in your scenario to do a lookup to the DB to see if the given record exists (using a Decision shape for example) and then respectively route to a dynamic INSERT or UPDATE map profile/connector operation?
Retrieving data ...