QVD Snapshots

vitaliichupryna — Sat, 16 Nov 2024 04:56:51 GMT

Hi,

I'm working on the daily DB shapshots, for this I use qvd files. I want have incremental reload, in my qvd table I should have following structure:

Key, Measure1, Measure2, … MeasureN, SnapshotDate.

As table in DB is pretty big, I need store data into qvd only when DB row is updated.

instead of:

Key, Measure1, Measure2 , SnapshotDate

1, 10, 50, 12/1/2018

1, 10, 50, 12/2/2018

1, 10, 50, 12/3/2018

1, 11, 55, 12/4/2018

I need have:

Key, Measure1, Measure2 , SnapshotDate

1, 10, 50, 12/1/2018

1, 11, 55, 12/4/2018

Main problem for me is that table in DB doesn't contain Modified Date, so I see only one way to reach my goal is to create generic key with all fields in table and than compare Key from DB and from qvd file

Please let me know if you have better solutions.

Re: QVD Snapshots

dplr-rn — Mon, 17 Dec 2018 16:32:48 GMT

I believe that is the only solution.

One suggestion i would have is a hash function as the fingerprint (generickey) as it is quite quick.

Have you checked Robs QVC . it has some subroutines that you can reuse. it may not be directly applicable but can point you in right direction from a design efficiency point of view

https://qlikviewcookbook.com/2012/01/incremental-load-using-qlikview-components/

topic Re: QVD Snapshots in QlikView

QVD Snapshots

Re: QVD Snapshots