While the Table output step allows you to insert brand new data, the Insert / Update step allows you to do both, insert and update data in a single step.
The rows directed to the Insert / Update step can be new data or data that already exists on the table. Depending on the case, the Insert / Update step behaves differently. Before explaining each case, let's introduce the step. The following image corresponds to the Insert / Update configuration window:
As you can see, the upper section is identical to the Table output window. Here, you select the database connection ...