QVD files for incremental load using Insert, update and delete

[karan_kn]

Existing QVD -->Concatenate with--> DB data using incremental load (Insert, update and delete)

Final:

LOAD

Sales_date,

Type,

ID

From Test.qvd(qvd);

Concatenate

LOAD

Sales_date,

Type,

ID

FROM DB_TABLE;

STORE temp_Final into Test.qvd(qvd);

[YoussefBelloum]

Where is the question here ??

[jonathandienst]

To handle updates and deletes, you will need a unique identifier field and a last updated field (or something to determine if the line has changed since the last load, such as sequential ID numbers).

If you ask more specific questions, you will get more useful suggestions.