topic Incremental Load in QlikView

Incremental Load

Mon, 20 Feb 2012 05:33:50 GMT

Hello,

We are using stored Procedures (developed in sql server2008 )for fetching data in qlikview Reports.

Please can anyone tell me how to do incremental load and also storing earlier fetched data.

Incremental Load

jagan — Mon, 20 Feb 2012 09:23:18 GMT

Hi,

Incremental loading is a big concept, you can found the examples of all types of incremental loading in Qlikview Help file and also in Qlikview reference file.

Regards,

Jagan.

Incremental Load

Thu, 01 Mar 2012 06:58:30 GMT

I tried many examples, but it is not working.

I found some examples where it is picking data directly from the table (means select statement is written direclty in the QV script.). But we are calling stored procedures.

So please help us on that front.

Re: Incremental Load

jagan — Thu, 01 Mar 2012 07:10:32 GMT

Hi,

Select Statement should fetch only latest data, it should not fetch all the data. For implementing the Incremental load you should have a field like LastModifiedOn, which specifies you date of last modification of the record.

If you use stored procedure your stored procedure should fetch only the latest data, or you need to filter the latest data in qlikview.

For implementing Incremental Load, you have to fetch latest records based on the date field and last reload time.

Now concatenate the existing records in QVD.

For better understanding you can go through this concepts in Help you.

Hope this helps you.

Regards,

Jagan.

Re: Incremental Load

CELAMBARASAN — Thu, 01 Mar 2012 07:16:52 GMT

Hi,

Incremental load can only happen with stored procedure if there is possibility to pass date to procedure and inside you have compared it.

For more details about the incremental load have look in to the attached ppt.

Hope it helps

Celambarasan

Incremental Load

Mon, 09 Apr 2012 09:17:46 GMT

Done