Both the matched and non-matched rows are fed into the upsert iterator.

Only the fields in the object that are qualified for the UPSERT operation are displayed.

It provides the functions for executing the SQL select/insert/update/upsert/delete statements via the Teradata DBC/SQL partition.