Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
Where is the question here ??
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.