Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist
Specialist

What is the difference between Partial load and Incremental load ??

Hey,

What is the difference between Partial load and Incremental load ?? And when both of them should be used ??

Thanks

1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

Hi,

In partial reload we can use ADD only or REPLACE only prefix in load statement and add or replace the new entries as per our requirment.

Regards

KC

Best Regards,
KC

View solution in original post

14 Replies
amit_saini
Master III
Master III

Nikhil,

Partial reload executes a specific part of your sciprt, this can for example be used to refresh a certain table.

Incredemental reload is defined in the script to update certain tables incredementally, for example to add only new transactions to a transaction table.

Incremental reload is especially used to decrease the reload time, by for instance only loading new records from a data source instead of the complete table (which can be very big).

Thanks,

AS

nikhilgarg
Specialist
Specialist
Author

HEy,

Does Partial reload only used to load newly added columns in data source ?? IS it so??

If yes then how does partial reload works?? It automatically detects the newly added column??

sundarakumar
Specialist II
Specialist II

Partial load is like run first 100 rows or n number of rows u specify.

It has no logic to look for what data to reload it blindl reload tehe first 10 or 100 or specified number of columns.

sundarakumar
Specialist II
Specialist II

it is used to test if the script will run without any errors in case if u have millions of data...

Incremental load is somethign much more useful where u go to load only what is added or altered....

Partial load is just for checking if ur logic in scripting like resident joins are working good...

The result of the partial reload may ahve that that are un assocaited.  There will be link bec of same col name. but we cannot be sure if data is available in both the tables.

Not applicable

amit_saini
Master III
Master III

Nikhil,

Yes it is , Partial Reload is used to add a new table without reloading existing tables in Qlikview file .

For better understanding follow link in attachment.

Thanks,

AS

jyothish8807
Master II
Master II

Hi,

In partial reload we can use ADD only or REPLACE only prefix in load statement and add or replace the new entries as per our requirment.

Regards

KC

Best Regards,
KC

View solution in original post

nikhilgarg
Specialist
Specialist
Author

HEy,

We do the partial load by clicking the partial reload option in file tab.

But does ADD and Replace options are second way for partial reload without clicking partial reload option ??

nikhilgarg
Specialist
Specialist
Author

HEy,

We do the partial load by clicking the partial reload option in file tab.

But does ADD and Replace options are second way for partial reload without clicking partial reload option ??