Which is the best way to create then use a QVD file?

[josephinetedesc]

Hi

1.     I have a qlkview document getting data from a production server hourly (consider getting of the production server - that is another question!)

2.     In the mornings or when requested I run another qlikview document which gets data from the production server and creates a qvd file.

In some documents a daily update is fine - that is why I use 2.

Would it cause an extra load on the server if when the production server was polled hourly it also created a qvd document?

I know that for the future I will need to look at some other method and I will need to look at incremental loads - but for the moment I just want to deal with this question.

Thank you

Jo

[nagaiank]

It depends on ow you design your data model.

If the hourly data is designed to incrementally insert data in one of your files, you can create tasks to extract and data hourly in the production server and update your data model hourly.

[josephinetedesc]

Thank you Nagaian

that will certainly be something I will need to look at, but meanwhile will it "hurt" if I create a QVD file at the same time as the server is polled hourly?

Jo

[SreeniJD]

Hi Jo

As per your requirement you can do number of incremental loads, even hourly(provided your load is taking less than 1 hour time).

The best way to do this is... to schedule the load through windows batch file by executing the following script...

"C:\Program Files\QlikView\Qv.exe" /r "D:\Filename.qvw"

HTH

Sreeni

[Anonymous]

Hi Josephine,

If said Qlikview document is reloaded hourly?,generating QVD should not be a issue.

Thanks

Neetha

[josephinetedesc]

Thank you Neetha

I will ask the administrator to maybe trial it after hours.

Jo