QVD Snapshots

[vitaliichupryna]

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.

[dplr-rn]

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/