topic Re: Need help on Increamental load..?? in QlikView

Need help on Increamental load..??

vishalgoud — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

we want to implement the Incremental scenario for our project which includes 24 tables of data.

and in total we have some 12 sheets/reports for which we will get the fields from all the tables.

Ex: for reports 1-5 we need first 5 tables , for report 6 we need some 2 tables etc.

Requirement : new records load will be done once in a month , so we can use as date as a parameter to implement this.

and date is Present in separate table.

here my doubt is for which tables I have to write incremental script is it for the fact tables (tables that have fields which are used for measure calculation ) and date table. or for all tables.

Appreciate all your response to this issue.

Regards,

Re: Need help on Increamental load..??

Anonymous — Fri, 16 Sep 2016 06:49:02 GMT

Have a look it covered all scenarios

Incremental Load in Qlikview - Sources

Hope it helps!!

Re: Need help on Increamental load..??

beck_bakytbek — Fri, 16 Sep 2016 08:11:16 GMT

Hi vishal,

take a look for this Video, very nice explained:

Incremental Load in Qlikview - YouTube

i hope that helps

beck

Re: Need help on Increamental load..??

sasikanth — Fri, 16 Sep 2016 08:29:05 GMT

HI ,

Inc load is obviously on fact tables and use the date field from fact table itself.

use ETL_LOAD Dates if no other date fields are available in fact table .