Files QVD

[Timario]

Hello to All.

I have connect to my DB, but these table without index(id).

How I can add only new rows in created qvd file?

[Or]

How do you know a row is new? if it's because it doesn't match any rows in the file, you could just combine the existing qvd with the full db query and load only distinct values. Otherwise, you need something which tells you the row is new...

[Timario]

If I doesn't have any signal about new rows, I should load whole file?

[Or · Accepted solution]

If there's no way to tell whether a row is new, then there's no way to do what you want. You need some sort of indicator.

[SunilChauhan]

there should be some  lastmodified or updateddate

you can find Max modfield date and  add below to qvd  as we do in incremental load

set it into a Variable ; vMaxModified

Test:

Load * from qvd;

concatenate

table:

Load * from  table.QVD;

concatenate

Select * from DbTable where Lastmodifiedfield> $(vMaxModified);

Store table into table.qvd;