topic Re: What is the difference between Partial load and Incremental load ?? in QlikView

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

nikhilgarg — Thu, 25 Sep 2014 05:53:39 GMT

Hey,

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

Thanks

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

amit_saini — Thu, 25 Sep 2014 05:57:11 GMT

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,

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

nikhilgarg — Thu, 25 Sep 2014 06:09:54 GMT

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

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

sundarakumar — Thu, 25 Sep 2014 06:12:32 GMT

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.

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

sundarakumar — Thu, 25 Sep 2014 06:14:53 GMT

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.

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

Thu, 25 Sep 2014 06:18:08 GMT

see link

For partial load:--

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

For incremental load:-

Incremental load in Qlikview

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

amit_saini — Thu, 25 Sep 2014 06:19:01 GMT

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,

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

jyothish8807 — Thu, 25 Sep 2014 06:40:30 GMT

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

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

nikhilgarg — Thu, 25 Sep 2014 06:45:27 GMT

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

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

nikhilgarg — Thu, 25 Sep 2014 06:45:39 GMT

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

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

nikhilgarg — Thu, 25 Sep 2014 06:45:49 GMT

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

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

jyothish8807 — Thu, 25 Sep 2014 07:16:55 GMT

No Nikhil, ADD and REPLACE are actions which we perform while doing partial reload.

Regards

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

nikhilgarg — Thu, 25 Sep 2014 08:30:23 GMT

Can you please explain it more why we use ADD and Replace ??

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

ngulliver — Thu, 25 Sep 2014 08:45:36 GMT

Hi, Nikhil.

This looks like an exam question. The reason I say this is that we have had other identical questions. It may be worth searching this forum for an answer to your question before posting a new one. You will get the information faster 😉

Regards,

Neil

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

ngulliver — Thu, 25 Sep 2014 09:21:41 GMT

If you get a slow response or stuggle to find what you want on this forum, I should also add that there is a good website called AskQV.com which searches the blogs of respected QlikView developers (who are also on this community) for articles related to your question.