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.
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.
