Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
When to use Upsert, Append and Overwrite in RDBMS Writer component
#1

  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. 
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)