incremental load without date fields ?

[#1]

Hello everyone,

I have an application in which I load data from the database without almost any transformation and then store the tables in qvd files.

I don't have any date fields like "creating data" or "modification date".  I was wondering if there was any tips to use kind of incremental load ?

Can I compare the values to the ones existing in the qvd and then add only the new lines ? But if I have to compare each record of the table to each record of the QVD, would that improve the performance ?

Thank you for your anwers

[MK_QSL]

What is the primary key in your database?

[ashfaq_haseeb]

Possible,

But atleast you need to have primary key.

Regards

ASHFAQ

[tresesco]

Incremental load without timestamp

Incremental Load without date feild

[#5]

Hello,

Yes, in each table, there is an "id".

From what I've read, I can do insert but not update ?

[tresesco]

That's true. Without modification timestamp (and actually not comparing all field values -which beats the purpose of incremental load) updated records would not be possible to identify.

[#7]

I would like to try it but I cannot find the proper syntax:

LOAD

    1 as Compteur_Location, 

    id,

....

    ;

SQL SELECT *

FROM "MyTable";

where id not in

LOAD id from

Lala\MyTable.qvd

(qvd);

id is the primary key.

ANy ideas ?

Thank you

[#8]

I have lso tried this one :

LOAD id from

MyTable.qvd

(qvd) ;

Concatenate

LOAD

    1 as Compteur_Location, 

    id,

  ...

    where not exists(id);

SQL SELECT *

FROM MyTable

;

But again all the table is reloaded...