The Update operator, a consumer operator, emulates the Teradata MultiLoad utility to perform highly scalable and parallel Inserts, Updates, Deletes, and Upserts into new or preexisting database tables in a single pass. The Update operator can also be used to insert new rows into the database, but it cannot perform Select operations.