topic Partial Reload for Incremental Load? in QlikView https://community.qlik.com/t5/QlikView/Partial-Reload-for-Incremental-Load/m-p/1334680#M822010 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Coming from a performance perspective: my data refresh is a 3 stage process:</P><P>1. ODI ETL from a transactional DB to an Enterprise Data Warehouse (EDW)</P><P>2. QVW to extract tables from EDW into QVDs. This is an incremental load</P><P>3. QVW to read from QVDs. </P><P></P><P>For stage 3, I am currently using a default full load to load the QVDs into the QVW. It will do this full load every hour.</P><P>I am wondering if there are performance benefits to using a partial reload to ADD new records from the QVD, and REPLACE updated records. </P><P></P><P>Does anybody know if there are substantial performance improvements, if it is even possible? Thanks in advance!</P><P></P><P>Sincerely,</P><P>Kerk</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT kerkying 2020-11-25T16:16:04Z Partial Reload for Incremental Load? https://community.qlik.com/t5/QlikView/Partial-Reload-for-Incremental-Load/m-p/1334680#M822010 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Coming from a performance perspective: my data refresh is a 3 stage process:</P><P>1. ODI ETL from a transactional DB to an Enterprise Data Warehouse (EDW)</P><P>2. QVW to extract tables from EDW into QVDs. This is an incremental load</P><P>3. QVW to read from QVDs. </P><P></P><P>For stage 3, I am currently using a default full load to load the QVDs into the QVW. It will do this full load every hour.</P><P>I am wondering if there are performance benefits to using a partial reload to ADD new records from the QVD, and REPLACE updated records. </P><P></P><P>Does anybody know if there are substantial performance improvements, if it is even possible? Thanks in advance!</P><P></P><P>Sincerely,</P><P>Kerk</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Partial-Reload-for-Incremental-Load/m-p/1334680#M822010 kerkying 2020-11-25T16:16:04Z Re: Partial Reload for Incremental Load? https://community.qlik.com/t5/QlikView/Partial-Reload-for-Incremental-Load/m-p/1334681#M822011 <HTML><HEAD></HEAD><BODY><P>I don't think so whether performs improve for this case because even you are doing Partial Reload by using ADD / REPLACE.</P><P></P><P>But, as per my experience if you use either one of ADD / REPLACE off course, You may get saves the time to reload.</P></BODY></HTML> Wed, 02 Aug 2017 11:42:33 GMT https://community.qlik.com/t5/QlikView/Partial-Reload-for-Incremental-Load/m-p/1334681#M822011 Anil_Babu_Samineni 2017-08-02T11:42:33Z