topic Re: Incremental Load in QlikView

Incremental Load

Wed, 27 Jun 2012 12:36:07 GMT

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

Re: Incremental Load

Wed, 27 Jun 2012 13:09:04 GMT

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

Re: Incremental Load

Wed, 27 Jun 2012 13:21:32 GMT

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

Re: Incremental Load

Wed, 27 Jun 2012 14:33:24 GMT

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