topic Update in Incremental load using Primary Key in QlikView

Update in Incremental load using Primary Key

bhavikumehta — Sat, 16 Nov 2024 04:47:05 GMT

I have a DB table with a Primary key, without a Date field.

Requirement is to use Incremental load - I am able to pull newly Inserted, Deleted records using Primary key, however, unable to pull Updated records using Primary key.

Please let me know solution for pulling Updated records in Incremental load using Primary Key. Thank you.

Re: Update in Incremental load using Primary Key

dplr-rn — Fri, 11 Jan 2019 12:27:26 GMT

You will need to use a hash key got each row.
I.e.
Hash256(column 1, column 2,...)
This creates a unique signature for each row
Load data where hash keys doesn't exist.

But how much benefit it gives as far as load time is questionable as you will need to query the entire db anyway.

Hope it helps