Delta Loads from QVD to SQL

Hi,

Is it possible to load(append) only new non-existing records from QVD to SQL table, also update the changed records on the existing SQL table data.

Regards.

Hi @kgopane and welcome to the Community!

You can use the “Select matching rows” action to check whether data already exists in the database table, then split the QVD data into two derived tables. Use “Export to database table” to insert new records in one derived table. Use the “Update database table” action in the other derived table with existing rows to update the database table.

See also:

1 Like