topic Qvd will be affected, if while doing incremental load connection to the data-source drops. in QlikView

Qvd will be affected, if while doing incremental load connection to the data-source drops.

Sat, 14 May 2011 18:26:39 GMT

Hi,

Qvd will be affected, if while doing incrementalload connection to the data-source drops?

Please tell me how it is?

Qvd will be affected, if while doing incremental load connection to the data-source drops.

fosuzuki — Sun, 15 May 2011 03:57:20 GMT

Hi,

Basically, when you are using incremental load, you'd follow the steps:

1. load the new data from datasource into a temporary table

2. concatenate the temporary table with the data loaded from the QVD

3. store the temporary table into the QVD

If the connection to the data-source drops, your script will fail in the step 1, and will not go through steps 2 and 3. So, the QVD file will not be modified and will maintain its data from the last successful script execution.

Of course this answer may not apply to your case depending on how you developed the load script...

Hope this helps you.

Regards,

Fernando Suzuki

Qvd will be affected, if while doing incremental load connection to the data-source drops.

Mon, 16 May 2011 19:44:03 GMT

Hi,

As per your explenation if we drop connection between data souce and qvd then there is no effect to qvd,right.

Thank You Fernado.

Qvd will be affected, if while doing incremental load connection to the data-source drops.

suniljain — Tue, 17 May 2011 11:38:24 GMT

can you post more details because I think have still confusion on Increamental load .

Re: Qvd will be affected, if while doing incremental load connection to the data-source drops.

fosuzuki — Fri, 20 May 2011 00:45:45 GMT

HI suniljain,

check the attached documents detailing the incremental load strategy.

Regards,

Fernando