Reload new data

[Anonymous]

Guys,

I have two dimensions,

1. Customer

2. Mapping

Whenever the QVW is reloaded, new customer can be added and also mapping.

For these two dimensions, there are some conditions

1. New Customer table needs to be reloaded once per week and

2. Mapping table has to be reloaded once per day.

Can we achieve this? If yes, please suggest an idea and also I need to do this reload using windows task scheduler, since I'm using personal edition of QV.

[tomasz_tru]

You dan store Your data into separate QVD files and use those by the final QV application.

[Anonymous]

Can I use Partial reload for this scenario?

[Or]

You could, but then you would have to time the model to do partial reloads every day and full reloads once a week.  It would also be more fiddly to set up properly.

A QVD-based approach would be better. You could do this by splitting the loads into two QVWs (one creating each QVD) and scheduling them as appropriate, or you could read the existing QVD and decide whether or not to load fresh data based on the data / metadata of that QVD - that approach would be better if it's important for you to package this entire thing in one QVW.

[Anonymous]

Thanks for your suggestion, Shoham. As suggested, I need to package this entire thing in one QVW. Could you please share in detail how to do this by script wise.

[santiago_respane]

Hi Siva,

you can use a metada QVD with the last update date for each QVD and then perform de reload based on a condition for each different QVD.

The metada QVD shoud have the following columns:

*QvdName

*LastUpdate

*UpdateFrequency

In your load script you shoud check, for each QVD, if the last updated date plus the frequency es equal to the current date and then peform the reload if condition is true. After the reload is performed succesfully update you meta data QVD with the new last update date for the current QVD file.

This is a very simple and basic way to resolve your issue in one QVW file. Let me know if it helps.

Kind regards,