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

[nikhilgarg]

Hey,

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

Thanks

[amit_saini]

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]

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]

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]

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.

[#6]

hi

see link

For partial load:--

What is meant by partial reload? What is its use? Please explain!

For incremental load:-

Incremental load in Qlikview

[amit_saini]

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 · Accepted solution]

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

[nikhilgarg]

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]

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 ??