Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
bhavikumehta
New Contributor III

Update in Incremental load using Primary Key

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.

1 Reply
Partner
Partner

Re: Update in Incremental load using Primary Key

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