Have you already done research on this through a google search? If not, then take a look at some of these links
Thanks for sharing those link. Really helpful. Thanks a lot. But, still I got one doubt when I was doing some research on my own.
Lets say we have Customer table. Which had 3 cust yesterday and today 2 have added.
Yesteday Today Cust ID Cust Name Cust ID Cust Name 1 Alex 1 Alex 2 Berry 2 Berry 3 Roger 3 Roger 4 Thomas 5 Stuart
Now if I use Partial re laod with below script:
LOAD [Cust ID],
(ooxml, embedded labels, table is Customer);
ADD LOAD [Cust ID],
(ooxml, embedded labels, table is Customer_New)
where NOt Exists ([Cust ID]);
Then What would be the difference of result if do Incremental Load. Please clarify my doubt.
Thanks a lot for your help..
A partial reload happens in the context of the resident, in-memory data model. It tells Qlik not to drop the complete data model when doing the script reload and do a full reload, but keep some data tables and add / replace data in other tables.
An incremental (or sometimes called Delta) LOAD is a more basic concept which is not limited to the context of the in-memory data model.
For example, it's often used when creating QVDs from source data base tables. You may want to only query the source DB for new, updated or deleted records (in comparison to an existing QVD), not pulling all data in. But your QVD should finally be updated to represent the current state of the DB table.
Here, you can't use a partial LOAD because there is in general no data model that will be kept in memory till the next reload.
Hope this helps,