topic Re: Incremental load in QlikView

Incremental load

prabhas277 — Mon, 16 Mar 2015 10:56:30 GMT

What is incremental load ?and explain practically how insert,insert &Update and delete works in incremental load ?

Thanks in advance

awhitfield — Mon, 16 Mar 2015 11:25:44 GMT

Hi Prabhas,

there's a whole section on this topic, in the Qlikview Reference Guide, Section 28.4

Andy

buzzy996 — Mon, 16 Mar 2015 11:30:39 GMT

Incremental load is concept in Qlikview to use/load only recent records.

for example: if ur having data from 1st jan 2015 to 15 Mar 2015 in ur qlikview application,but i need to load only 16 march data on mar 17.

and in other way need add mar 16 th data to old data (1st jan 2015 to 15 mar 2015) in ur application with out loading data from jat 1st.

we have to use the concept incremental load based on ur date keys in ur load scripts.

Mon, 16 Mar 2015 11:33:26 GMT

Hi ,

Hope it will help you to understand with exp..

PFA,

Thanks & regards,

Harshal

Mon, 16 Mar 2015 13:14:59 GMT

Check this link for you clean understand in Incremental Load

See this Pdf for example also