Forums

Forums > BDB Knowledge Base > BDB Data Pipeline > BDB Data Pipeline Q & A > When to use Upsert, Append and Overwrite in RDBMS Writer component
Full Version: When to use Upsert, Append and Overwrite in RDBMS Writer component
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

gnanashri

12-23-2022, 10:51 AM

  1. Overwrite, overwrites the data upon the tables, can be used when you need to change the existing data in the table to the new data 
Append, appends on/ adds on to the existing data that is already written in the table.  
Upsert, updates and inserts the new data to the previous data in the table. 
Forums > BDB Knowledge Base > BDB Data Pipeline > BDB Data Pipeline Q & A > When to use Upsert, Append and Overwrite in RDBMS Writer component