Forums › BDB Knowledge Base › BDB Data Pipeline › BDB Data Pipeline Q & A v
When to use Upsert, Append and Overwrite in RDBMS Writer component

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
When to use Upsert, Append and Overwrite in RDBMS Writer component
gnanashri Offline
Junior Member
**
Posts: 20
Threads: 20
Joined: Dec 2022
Reputation: 0
#1
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. 
Find
Reply


Messages In This Thread
When to use Upsert, Append and Overwrite in RDBMS Writer component - by gnanashri - 12-23-2022, 10:51 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)