Choosing a pipeline operation – PB Docs 2019

Create – Add Table

A new table is created and rows selected from the
source tables are inserted.

If a table with the
specified name already exists in the destination database, a
message displays and you must select another option or change
the table name.

Replace – Drop/Add Table

An existing table with the specified table name
is dropped, a new table is created, and rows selected from the
source tables are inserted.

If no table exists
with the specified name, a table is created.

Refresh – Delete/Insert Rows

All rows of data in an existing table are
deleted, and rows selected from the source tables are
inserted.

Append – Insert Rows

All rows of data in an existing table are
preserved, and new rows selected from the source tables are
inserted.

Update – Update/Insert Rows

Rows in an existing table that match the key
criteria values in the rows selected from the source tables
are updated, and rows that do not match the key criteria
values are inserted.