Incremental Load

[#1]

Hi all,

I am using the fallowing script to in QVD generator(maker) application  to generate QVD for each table. Right now i am doing full reload, How can i achive incremental load ? 

LET Starttime =Now();
Fact_Orders:
LOAD *;
SQL SELECT *
FROM "Company_ORD".dbo."Fact_Orders";
LET Endtime =Now();
LET NoOfRows =noofrows('Fact_Orders');
Load * inline
[
TableName,Starttime,Endtime,NoOfRows
Fact_Orders,'$(Starttime)','$(Endtime)','$(NoOfRows)'
];
CALL StoreAndDrop('$(Stage1)','Fact_Orders');  

Appreciate any help on this

Thanks

[#2]

Do you have a modification date field?

take a look of this: http://www.resultdata.com/qlikview-incremental-loads-and-qvds/

I hope it helps

[#3]

Hi luchomaxis,

I do have modification time and Primarykey ....... should i use Incremental load script based on modification time and Primarykey in QVD Generator app and generate daliy QVD's ?

Thanks

[#4]

I guess the frecuency of the reload depends of your needs.

Take a look of this post. could be helpful as well:

http://community.qlik.com/message/232067#232067