What Is The Difference Between Update And Upsert?

What Is The Difference Between Update And Upsert? A Database Update activity updates existing data in a Database endpoint, while a Database Upsert activity both updates existing data and inserts new data in a Database endpoint. Both are intended to be used as a target to consume data in an operation or to be called