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

[#1]

Hi,

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

Please tell me how it is?

[fosuzuki]

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

[#3]

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.

[suniljain]

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

[fosuzuki]

HI suniljain,

check the attached documents detailing the incremental load strategy.

Regards,

Fernando